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

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