list or regular expressions

From: "Rhys Stewart" <rhys(dot)stewart(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: list or regular expressions
Date: 2006-06-26 20:11:11
Message-ID: 189966030606261311p26eb887bp2c92105442501d9d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-26 20:19:40 Re: list or regular expressions
Previous Message Martijn van Oosterhout 2006-06-26 19:57:02 Re: limit over attribute size if index over it exists