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)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Error in Makefile.tcldefs
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Error in Makefile.tcldefs