Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Johann Spies
Date:
The following illustrates the problem (removing double quotes from a string):


js=# select regexp_replace(regexp_replace( '"University of Cape Town"', '^"', ''),'"$', '');
     regexp_replace     
-------------------------
 University of Cape Town
(1 row)

js=# trim(both '"' from '"University of Cape Town"');
ERROR:  syntax error at or near "trim"
LINE 1: trim(both '"' from '"University of Cape Town"');

Example from the documentation:

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.

Or is there another way?

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

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

From
Francisco Olarte
Date:
On Mon, May 20, 2019 at 12:09 PM Johann Spies <johann.spies@gmail.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.

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

From
Johann Spies
Date:
Thanks!

I was a bit stupid.

Johann


On Mon, 20 May 2019 at 12:18, Francisco Olarte <folarte@peoplecall.com> wrote:
On Mon, May 20, 2019 at 12:09 PM Johann Spies <johann.spies@gmail.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)