Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 7277F475872 for ; Thu, 18 Apr 2002 10:40:47 -0400 (EDT) Received: (qmail 21525 invoked by uid 0); 18 Apr 2002 14:40:51 -0000 Received: from pd9e0d660.dip.t-dialin.net (HELO wxp) (217.224.214.96) by mail.gmx.net (mp004-rz3) with SMTP; 18 Apr 2002 14:40:51 -0000 Message-ID: <015d01c1e6e7$6abe3a10$a57ba8c0@wxp> From: "Albrecht Berger" To: "pgsql" Subject: DISTINCT ON ... without distinct null values ? Date: Thu, 18 Apr 2002 16:43:25 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/225 X-Sequence-Number: 7489 Hello, I've got a table which I query with something like " SELECT DISTINCT ON("c") FROM table ... " . Not every row in the column "c" does have a value, some are null. My problem is, that I want to eliminate double values in "c" only if they are not null ! Does anybody has an idea ? Thx Albrecht