Subject Re: [IB-Architect] Re: [Bug #125218] NULLs always at the tail
Author Ann W. Harrison
At 07:56 AM 12/10/2000 -0500, Doug Chamberlin wrote:

>I think you could make a case for having NULLs always trail the non-NULL
>values in a result set, regardless of the requested sort order of the
>result set. While I can see the logic of thinking of NULL as a value which
>has a collation order, I can also see the logic of treating them as "and we
>also have these records which were produced but they don't quite fit in so
>we are sending them along at the end".

Logic has little to do with SQL and where Firebird uses standard SQL syntax,
we should use standard SQL semantics. Extensions are another issue.


We have answers.