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 > <[email protected] <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]
