Re: bug or feature, || -operator and NULLs - Mailing list pgsql-hackers

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