Re: using result as part of regular expression - Mailing list pgsql-general

larry a price writes:

> SELECT table1.name,table2.web,table2.email
> WHERE table1.name LIKE upper(table2.name).'%';
>                     ^^^^^^ trying for
>                     'content%'

|| is the operator for string concatenation.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/