Re: Re: Does PostgreSQL support EXISTS?

Поиск
Список
Период
Сортировка
От KuroiNeko
Тема Re: Re: Does PostgreSQL support EXISTS?
Дата
Msg-id 3B26EBFF.nailMJ1D8AHP@ed.ed
обсуждение исходный текст
Ответ на Re: Does PostgreSQL support EXISTS?  (Nils Zonneveld <nils@mbit.nl>)
Список pgsql-general
> Yes 'exists'  works (though I never understood the  advantage to the 'in'
operator).

 Each  has its  advantages and  weak points.  Eg, in  some DBMS,  number of
entries of `in ( A1, ... AN )' has a pretty tight limit. Also, in PGSQL 7.0
having even fewer  entries may cause `Tuple too big'  error. Solution is to
replace explicit enumeration with comparisons. And so on.
 `exists'  is more  `relational pure'  on one  hand, but  is probably  more
resource consuming.


--

 ������������������


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

Предыдущее
От: Zak McGregor
Дата:
Сообщение: Re: OIDS in views
Следующее
От: Michael Dunn
Дата:
Сообщение: Re: PLPGSQL: Using SELECT INTO and EXECUTE