DISTINCT ON ... without distinct null values ?

From: "Albrecht Berger" <berger1517(at)gmx(dot)ch>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: DISTINCT ON ... without distinct null values ?
Date: 2002-04-18 14:43:25
Message-ID: 015d01c1e6e7$6abe3a10$a57ba8c0@wxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-04-18 15:43:53 Re: SQL Query Optimization
Previous Message Christoph Haller 2002-04-18 14:04:35 now() does not change within a transaction