Thread: list or regular expressions
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.
"Rhys Stewart" <rhys.stewart@gmail.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
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.