DISTINCT ON ... without distinct null values ? - Mailing list pgsql-sql

From Albrecht Berger
Subject DISTINCT ON ... without distinct null values ?
Date
Msg-id 015d01c1e6e7$6abe3a10$a57ba8c0@wxp
Whole thread Raw
Responses Re: DISTINCT ON ... without distinct null values ?  (Fduch the Pravking <fduch@antar.bryansk.ru>)
List 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







pgsql-sql by date:

Previous
From: Karel Zak
Date:
Subject: Re: Migrating Oracle to PostgreSQL
Next
From: "Josh Berkus"
Date:
Subject: Re: SQL Query Optimization