Re: list or regular expressions

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: list or regular expressions
Дата
Msg-id
22528.1151353180@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
list or regular expressions "Rhys Stewart" <rhys.stewart@gmail.com>
Re: list or regular expressions Tom Lane <tgl@sss.pgh.pa.us>
Re: list or regular expressions Mischa Sandberg <mischa@ca.sophos.com>
"Rhys Stewart"  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 " 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
В списке pgsql-general по дате отправления
От: Rhys Stewart
Дата:
Сообщение: list or regular expressions
От: Tom Lane
Дата:
FAQ