Postgres Pro
Downloads
Home   >   mailing lists

SELF LEFT OUTER JOIN = SELF JOIN including NULL values - Mailing list pgsql-general

From julia.jacobson@arcor.de
Subject SELF LEFT OUTER JOIN = SELF JOIN including NULL values
Date
Msg-id 11663360.1284740204627.JavaMail.ngmail@webmail17.arcor-online.net
Whole thread Raw
Responses Re: SELF LEFT OUTER JOIN = SELF JOIN including NULL values  (Raymond O'Donnell <rod@iol.ie>)
Re: SELF LEFT OUTER JOIN = SELF JOIN including NULL values  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Tree view 
Hello everybody out there using PostgreSQL,

After having read the official documentation and having done extensive web search, I'm wondering how to perform
somethinglike a SELF LEFT OUTER JOIN in PostgreSQL, i.e. a SELF JOIN on a table containing NULL values in one of the
columnsto 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
wichtigstenNews, Trends und Gadgets der IFA vor. Natürlich mit dabei: das brandneue IPTV-Angebot von Vodafone! Alles
rundum die Internationale Funkausstellung in Berlin finden Sie hier: http://www.arcor.de/rd/footer.ifa2010

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: where does postgres keep the query result until it is returned?
Next
From: Raymond O'Donnell
Date:
Subject: Re: SELF LEFT OUTER JOIN = SELF JOIN including NULL values