Re: list or regular expressions

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Rhys Stewart" <rhys(dot)stewart(at)gmail(dot)com> writes:
> can i search in a list or regular expression....eg

> "select yadi from ya where yadiya in ('old', 'ulk', 'orb')"

> but instead of in ther'd be another operator or a LIKE IN.

You could use "<operator> ANY" --- "IN" is just a shorthand for "= ANY".
I don't think the parser will take LIKE ANY, but you could use the
equivalent operator name ("~~" I think, check the manual).

			regards, tom lane