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
> > <svanderclock@... <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]