Re: IN Operator query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: IN Operator query
Дата
Msg-id 23785.1341499477@sss.pgh.pa.us
обсуждение исходный текст
Ответ на IN Operator query  (DrYSG <ygutfreund@draper.com>)
Список pgsql-novice
DrYSG <ygutfreund@draper.com> writes:
> My naïve hope was that if iFILTER was set to: "CADRG, DTED1, DTED2, SRTF"
> (cat.type in (iFilter)) would expand to:
> (cat.type in (CADRG, DTED1, DTED2, SRTF))
> But that is not working.

Nope, it will not (and a good thing too IMO --- would you really want
commas in text strings to be dangerous?)

You might be able to do what you need by passing the argument as a text
array and using "cat.type = any(ifilter)".

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: DrYSG
Дата:
Сообщение: IN Operator query
Следующее
От: Michael Swierczek
Дата:
Сообщение: Re: IN Operator query