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

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