| 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: | Whole Thread | Raw Message | 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 |