Re: Found an example prooving bug
От | Bruce Momjian |
---|---|
Тема | Re: Found an example prooving bug |
Дата | |
Msg-id | 200105031921.f43JLpb12653@candle.pha.pa.us обсуждение исходный текст |
Ответ на | RE: Found an example prooving bug (Piers Scannell <piers.scannell@globecastne.com>) |
Ответы |
Sort ordering of NULLs (was Re: Found an example prooving bug)
|
Список | pgsql-bugs |
> >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
В списке pgsql-bugs по дате отправления: