From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Piers Scannell <piers(dot)scannell(at)globecastne(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org, "'mz174771(at)students(dot)mimuw(dot)edu(dot)pl'" <mz174771(at)zodiac(dot)mimuw(dot)edu(dot)pl> |
Subject: | Re: Found an example prooving bug |
Date: | 2001-05-03 19:21:51 |
Message-ID: | 200105031921.f43JLpb12653@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-05-03 19:30:20 | Re: freebsd sample startup script doesn't work |
Previous Message | Vivek Khera | 2001-05-03 19:11:56 | Re: freebsd sample startup script doesn't work |
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2001-05-03 19:24:31 | DBD::Pg errstr method doesn't return full error messages |
Previous Message | Bruce Momjian | 2001-05-03 19:20:58 | Re: Packaging 7.1.1 |