Re: Substring expression fails on single character input
=?UTF-8?Q?Per=2D=C3=85ke_Ling?= <[hidden email]> writes:
> When using the expression *'(\S.*\S)' *to remove surrounding whitespace
> (including \t and \n) it returns NULL on single character surrounded by
I see no bug there. The pattern requires two non-white-space characters
surrounding some arbitrary text, and your examples don't have that.
If your goal is to trim leading/trailing whitespace I'd suggest that btrim
is a lot easier route to the goal than coming up with a correct regex.