Bug in documentation (trim(...))?
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)
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.
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 cheaperfunction 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)