Rhys Stewart wrote:
Hi all,
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.
so it'd be a shorcut for typing yadiya ~* 'old' or yadiya ~* 'ulk' etc.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
you mean, like
yadiya ~ 'old|ulk'
(or parametrically)
yadiya ~ ?::text ||'|'|| ?::text ||'|'|| ... :-)
--
Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster