while you weren't looking, Caleb Simonyi-Gindele <csg(at)bordervet(dot)ca> wrote:
> How do I get it to produce a row even when dat_staff_code is null?
try something like
SELECT coalesce(dat_staff_code, 0)...GROUP BY dat_staff_code
That will substitute a zero for any NULL value in that column, which
GROUP BY should then pick up.
In response to
pgsql-sql by date
|Next:||From: sad||Date: 2004-07-20 05:36:44|
|Subject: locks and triggers. give me an advice please|
|Previous:||From: Caleb Simonyi-Gindele||Date: 2004-07-19 22:11:05|
|Subject: Group by failing on Null values|