Re: bug or feature, || -operator and NULLs

От: Robert Treat
Тема: Re: bug or feature, || -operator and NULLs
Дата: ,
Msg-id: 200610182127.58064.xzilla@users.sourceforge.net
(см: обсуждение, исходный текст)
Ответ на: Re: bug or feature, || -operator and NULLs  (Lukas Kahwe Smith)
Список: pgsql-hackers

Скрыть дерево обсуждения

bug or feature, || -operator and NULLs  (Andreas Joseph Krogh, )
 Re: bug or feature, || -operator and NULLs  (Csaba Nagy, )
  Re: bug or feature, || -operator and NULLs  (Andreas Joseph Krogh, )
   Re: bug or feature, || -operator and NULLs  (Martijn van Oosterhout, )
    Re: bug or feature, || -operator and NULLs  (Lukas Kahwe Smith, )
   Re: bug or feature, || -operator and NULLs  (Csaba Nagy, )
   Re: bug or feature, || -operator and NULLs  (Jeff Davis, )
 Re: bug or feature, || -operator and NULLs  (Mario Weilguni, )
  Re: bug or feature, || -operator and NULLs  (Andreas Joseph Krogh, )
   Re: bug or feature, || -operator and NULLs  (Lukas Kahwe Smith, )
    Re: bug or feature, || -operator and NULLs  ("Mario Weilguni", )
     Re: bug or feature, || -operator and NULLs  (Andreas Joseph Krogh, )
      Re: bug or feature, || -operator and NULLs  ("Mario Weilguni", )
       Re: bug or feature, || -operator and NULLs  (Lukas Kahwe Smith, )
        Re: bug or feature, || -operator and NULLs  (Andrew Dunstan, )
         Re: bug or feature, || -operator and NULLs  ("Mario Weilguni", )
          Re: bug or feature, || -operator and NULLs  (Csaba Nagy, )
          Re: bug or feature, || -operator and NULLs  ("Jim C. Nasby", )
   Re: bug or feature, || -operator and NULLs  (Alvaro Herrera, )
   Re: bug or feature, || -operator and NULLs  (Csaba Nagy, )
   Re: bug or feature, || -operator and NULLs  (Peter Eisentraut, )
 Re: bug or feature, || -operator and NULLs  (Andrew Dunstan, )
  Re: bug or feature, || -operator and NULLs  (Andreas Joseph Krogh, )
   Re: bug or feature, || -operator and NULLs  (Andrew Dunstan, )
   Re: bug or feature, || -operator and NULLs  (Martijn van Oosterhout, )
    Re: bug or feature, || -operator and NULLs  (Jeff Davis, )
     Re: bug or feature, || -operator and NULLs  (Martijn van Oosterhout, )
      Re: bug or feature, || -operator and NULLs  (Markus Schaber, )
   Re: bug or feature, || -operator and NULLs  (Neil Conway, )
    Re: bug or feature, || -operator and NULLs  (Lukas Kahwe Smith, )
     Re: bug or feature, || -operator and NULLs  (Teodor Sigaev, )
     Re: bug or feature, || -operator and NULLs  (Robert Treat, )
 Re: bug or feature, || -operator and NULLs  ("Albe Laurenz", )

On Wednesday 18 October 2006 10:35, Lukas Kahwe Smith wrote:
> Neil Conway wrote:
> > I think a more sensible proposal could be made for some sort of optional
> > "compatibility mode", as has been discussed many times in the past:
> > different NULL handling could theoretically be part of an Oracle SQL
> > dialect.
>
> even more exciting in this context would be to add user controllable
> NULL sorting behaviour. afaik this is in sql:2003.
>

Something like 

pagila=# select staff_id from staff order by picture is not null;staff_id
----------       2       1
(2 rows)

pagila=# select staff_id from staff order by picture;staff_id
----------       1       2
(2 rows)

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL



В списке pgsql-hackers по дате сообщения:

От: Robert Treat
Дата:
Сообщение: Re: bug or feature, || -operator and NULLs
От: "Gurjeet Singh"
Дата:
Сообщение: Re: New CRC algorithm: Slicing by 8