Re: extend "group by" to include "empty relations" ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter pilsl <pilsl(at)goldfisch(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: extend "group by" to include "empty relations" ?
Date: 2007-12-13 22:17:37
Message-ID: 21414.1197584257@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

peter pilsl <pilsl(at)goldfisch(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-12-13 22:20:10 Re: Hash join in 8.3
Previous Message Andrew Sullivan 2007-12-13 22:17:24 Re: Better alternative for Primary Key then serial??