Re: [GENERAL] list or regular expressions

2006-06-26 Thread Mischa Sandberg
Rhys Stewart wrote: Hi all, can i search in a list or regular expressioneg "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.

Re: [GENERAL] list or regular expressions

2006-06-26 Thread Tom Lane
"Rhys Stewart" <[EMAIL PROTECTED]> writes: > can i search in a list or regular expressioneg > "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 " ANY" --- "IN" is just a shorthand for "= ANY". I don't think

[GENERAL] list or regular expressions

2006-06-26 Thread Rhys Stewart
Hi all, can i search in a list or regular expressioneg "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)