Subject Re: [firebird-support] FirebirdSS-1.5.2.4731-0 and order by NULLS FIRST | LAST
Author Helen Borrie
At 12:42 PM 1/08/2005 +0000, you wrote:
>I have a problem with this query:
>"SELECT KOD_ZONES FROM ZONES ORDER BY KOD_ZONES NULLS FIRST"
>
>On that query I get following error message:
>"Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
>48 NULLS"
>
>I think that version of FirebirdSS-1.5.2.4731-0 (from rpm package)
>should contain "order by nulls".

How could you order by nulls, exactly?

Your statement above is perfectly valid syntax for a Dialect 3
database. It won't work on a Dialect 1 database.

./heLen