On 9/2/2011 12:21 PM, Vander Clock Stephane wrote: > > 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> > <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 > > > > > . > > > What if you do a union of the not Null rows with the Null rows?
-- Thanks, Gordon [Non-text portions of this message have been removed]
