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