Re: Bug in documentation (trim(...))?

Thanks!

I was a bit stupid.

Johann

On Mon, 20 May 2019 at 12:18, Francisco Olarte <folarte(at)peoplecall(dot)com>
wrote:

> On Mon, May 20, 2019 at 12:09 PM Johann Spies <johann(dot)spies(at)gmail(dot)com>
> wrote:
> > The following illustrates the problem (removing double quotes from a
> string):
>
> Missing "select " in your examples, is it intentional?
>
> > js=# trim(both '"' from '"University of Cape Town"');
> > ERROR: syntax error at or near "trim"
> > LINE 1: trim(both '"' from '"University of Cape Town"');
> > js=# trim(both 'xyz' from 'yxTomxx');
> > ERROR: syntax error at or near "trim"
> > LINE 1: trim(both 'xyz' from 'yxTomxx');
> > ^
> > I would think that "trim" if it works in this case would be a cheaper
> function than using rexexp_replace twice.
>
> ( copied from your mail AFTER "select " ):
>
> $ select trim(both '"' from '"University of Cape Town"');
> btrim
> -------------------------
> University of Cape Town
> (1 row)
>
> $ select trim(both 'xyz' from 'yxTomxx');
> btrim
> -------
> Tom
> (1 row)
>
> Francisco Olarte.
>

--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)