SELF LEFT OUTER JOIN = SELF JOIN including NULL values

From: julia(dot)jacobson(at)arcor(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: SELF LEFT OUTER JOIN = SELF JOIN including NULL values
Date: 2010-09-17 16:16:44
Message-ID: 11663360.1284740204627.JavaMail.ngmail@webmail17.arcor-online.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everybody out there using PostgreSQL,

After having read the official documentation and having done extensive web search, I'm wondering how to perform something like a SELF LEFT OUTER JOIN in PostgreSQL, i.e. a SELF JOIN on a table containing NULL values in one of the columns to join.

Thanks in advance for your help,
Julia

Heute erleben, was morgen Trend wird - das kann man auf der IFA in Berlin. Oder auf arcor.de: Wir stellen Ihnen die wichtigsten News, Trends und Gadgets der IFA vor. Natürlich mit dabei: das brandneue IPTV-Angebot von Vodafone! Alles rund um die Internationale Funkausstellung in Berlin finden Sie hier: http://www.arcor.de/rd/footer.ifa2010

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-09-17 16:33:09 Re: SELF LEFT OUTER JOIN = SELF JOIN including NULL values
Previous Message Willy-Bas Loos 2010-09-17 14:51:46 Re: where does postgres keep the query result until it is returned?