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)