Re: IN vs equality (was Re: odd intermittent query hanging issue)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: IN vs equality (was Re: odd intermittent query hanging issue)
Дата
Msg-id 19656.1337527996@sss.pgh.pa.us
обсуждение исходный текст
Ответ на IN vs equality (was Re: odd intermittent query hanging issue)  (Chris Angelico <rosuav@gmail.com>)
Список pgsql-general
Chris Angelico <rosuav@gmail.com> writes:
> On Sat, May 19, 2012 at 3:09 AM, Steve Crawford
> <scrawford@pinpointresearch.com> wrote:
>> I also don't understand the "xcrm.channel_id in (1)" instead of
>> "xcrm.channel_id = 1" unless this is a generated query and there could be
>> multiple ids in that condition.

> Side point from this thread. Is there ever any difference between
> these two constructs?

According to transformAExprIn() in parse_expr.c, no.

            regards, tom lane

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Libpq question
Следующее
От: Poul Møller Hansen
Дата:
Сообщение: Re: Why are pg_restore taking that long ?