X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AE460D1B1EC for ; Mon, 19 Jul 2004 19:29:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34323-01 for ; Mon, 19 Jul 2004 22:29:40 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by svr1.postgresql.org (Postfix) with SMTP id D9E42D1B182 for ; Mon, 19 Jul 2004 19:29:36 -0300 (ADT) Received: by mproxy.gmail.com with SMTP id 55so187947rni for ; Mon, 19 Jul 2004 15:29:32 -0700 (PDT) Received: by 10.38.102.75 with SMTP id z75mr222465rnb; Mon, 19 Jul 2004 15:29:32 -0700 (PDT) Message-ID: <37d451f70407191529610a8eba@mail.gmail.com> Date: Mon, 19 Jul 2004 17:29:32 -0500 From: Rosser Schwarz To: Caleb Simonyi-Gindele Subject: Re: Group by failing on Null values Cc: pgsql-sql@postgresql.org In-Reply-To: <000001c46ddd$491501d0$c201a8c0@borderveygqj37> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <000001c46ddd$491501d0$c201a8c0@borderveygqj37> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/121 X-Sequence-Number: 18373 while you weren't looking, Caleb Simonyi-Gindele 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. /rls -- :wq