Re: extend "group by" to include "empty relations" ? - Mailing list pgsql-general

From Tom Lane
Subject Re: extend "group by" to include "empty relations" ?
Date
Msg-id 21414.1197584257@sss.pgh.pa.us
Whole thread Raw
In response to extend "group by" to include "empty relations" ?  (peter pilsl <pilsl@goldfisch.at>)
List pgsql-general
peter pilsl <pilsl@goldfisch.at> writes:
> But there is a problem now: There are also entries in fn_kat which dont
> have corresponding entries in fn_dokumente and this entries should be
> listed too. With the proper count=0 !!

> How to achieve this?

LEFT JOIN before the group by?

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Better alternative for Primary Key then serial??
Next
From: Gregory Stark
Date:
Subject: Re: Hash join in 8.3