Re: Outer join in postgresql

Поиск
Список
Период
Сортировка
От Peter Vazsonyi
Тема Re: Outer join in postgresql
Дата
Msg-id Pine.LNX.4.10.10006122011350.1782-100000@kredit.sth.szif.hu
обсуждение исходный текст
Ответ на Outer join in postgresql  ("Patrick Kay" <patk@auctionsolutions.com>)
Список pgsql-sql
On Mon, 12 Jun 2000, Patrick Kay wrote:

> I am looking for a way run an outer join in psql.  Can anyone help?
> 
> Informix has an "OUTER" keyword.  I don't see anything like this in the docs
> for psql.
> 
> Thanks much.
> -Pat Kay
> 

Hmmm... I don't now the exact definition of outer join.
I feel it may somethink like this:

SELECT * FROM a WHERE NOT EXISTS (SELECT id FROM b WHERE b.id=a.id);

This works in postgresql, but doesn't use indices ;(
I mean this runs an sequencial scan on a, and many index scan on b.
The result may be done with a special hash-join, but not in current
versions.
I have a strange sens, in 7.1 it will be... regards
--nek;(



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

Предыдущее
От: "Patrick Kay"
Дата:
Сообщение: Outer join in postgresql
Следующее
От: Ed Loehr
Дата:
Сообщение: Re: Outer join in postgresql