Thanks! I was a bit stupid.
Johann On Mon, 20 May 2019 at 12:18, Francisco Olarte <fola...@peoplecall.com> wrote: > On Mon, May 20, 2019 at 12:09 PM Johann Spies <johann.sp...@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)
