unfortunatly

If you override the default NULLs placement, no index will be used for
sorting. In Firebird 1.5,
that is the case with NULLS FIRST. In 2.0 and higher, with NULLS LAST on
ascending and
NULLS FIRST on descending sorts.

but i need the index :(

On 8/31/2011 12:17 AM, Mark Rotteveel wrote:
>
> On Tue, 30 Aug 2011 12:20:56 +0400, Vander Clock Stephane
> <svanderclock@... <mailto:svanderclock%40yahoo.fr>> wrote:
> > Hello,
> >
> > how to put the num value at the end of the result (and not at the
> > beginning) when we are doing
> >
> > select xxx order by xxx ASC
>
> Something like:
> ORDER BY field ASC NULLS LAST
>
> See also section Sorts in
> http://www.firebirdsql.org/pdfmanual/Firebird-Null-Guide.pdf
>
>


[Non-text portions of this message have been removed]