Subject | Re: [firebird-support] FirebirdSS-1.5.2.4731-0 and order by NULLS FIRST | LAST |
---|---|
Author | Helen Borrie |
Post date | 2005-08-01T13:22:52Z |
At 12:42 PM 1/08/2005 +0000, you wrote:
Your statement above is perfectly valid syntax for a Dialect 3
database. It won't work on a Dialect 1 database.
./heLen
>I have a problem with this query:How could you order by nulls, exactly?
>"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".
Your statement above is perfectly valid syntax for a Dialect 3
database. It won't work on a Dialect 1 database.
./heLen