Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux