Re: not in vs not exists - vastly diferent performance

Поиск
Список
Период
Сортировка
От Randolf Richardson
Тема Re: not in vs not exists - vastly diferent performance
Дата
Msg-id Xns9462D1831D7E0rr8xca@200.46.204.72
обсуждение исходный текст
Ответ на not in vs not exists - vastly diferent performance  ("Iain" <iain@mst.co.jp>)
Список pgsql-sql
"tgl@sss.pgh.pa.us (Tom Lane)" wrote in comp.databases.postgresql.sql:

> "Iain" <iain@mst.co.jp> writes:
> 
>> I found this interesting and thought I'd offer it up for comment.
> 
> You didn't say what PG version you are using, but I'd venture to bet
> it is pre-7.4.
       This must've been one of the enhancements.  =)

-- 
Sir Randolf, noble spam fighter - rr@8x.ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.


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

Предыдущее
От: treat00@yahoo.com (Thomas Reat)
Дата:
Сообщение: "on insert" rules happen before the insert?
Следующее
От: Randolf Richardson
Дата:
Сообщение: Re: Radius of a zip code