Re: Found an example prooving bug
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Piers Scannell <piers.scannell@globecastne.com>
Cc: pgsql-bugs@postgresql.org, "'mz174771@students.mimuw.edu.pl'" <mz174771@zodiac.mimuw.edu.pl>
Date: 2001-05-03T19:21:51Z
Lists: pgsql-bugs, pgsql-hackers
> >From my point of view, NULL is neither bigger, nor smaller, you can't > compare it with a number. > > So it just comes at the end if you sort at all. > > (Perhaps you need to take a think about what NULL means in your data. Should > NULL sort as if it's 0?, +infinity?, -infinity? if so why?) We have a TODO item: * Make NULL's come out at the beginning or end depending on the ORDER BY direction -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026