Re: How to use like with a list

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 11/18/11 12:37 PM, Gauthier, Dave wrote:
> bi_dev=# select name from test where name ~ '^(' || replace('jo,mo,do,fo', ',', '|') || ')l';
> ERROR:  argument of WHERE must be type boolean, not type text

ah, needs () around the right side of the ~ expression, not sure why.   
does ~ have higher expression priority than || or something?

	select name from test where name ~ ('^(' || replace(?, ',', '|') || ')l');

worked for me.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general