NULL sorts as largest?

From: "Dmitri Bichko" <dbichko(at)genpathpharma(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: NULL sorts as largest?
Date: 2003-05-27 20:08:15
Message-ID: 7A4ADADFC8AFF0478D47F63BEDD57CE30D090B@gpmail.gphq.genpathpharma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am noticing that null values come out as the largest value when
sorting on a field (or last with ASC and first with DESC). Is there any
way to change this behaviour? It's somewhat strange to do a descending
sort on a column and get all the stuff that's not there first.

Thanks,
Dmitri

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Powell 2003-05-27 20:24:37 Deleting duplicate records
Previous Message scott.marlowe 2003-05-27 20:08:12 Re: Postgresql on SUN Server