Subject | Re: [IBO] FB 2.0 com IBO 4.7.16 - Order of the null fields |
---|---|
Author | Paul Vinkenoog |
Post date | 2007-04-20T13:40:17Z |
Hello Nelson,
That's right: in Firebird 2 nulls appear at the "smallest" end of the
sort (unless overridden by NULLS FIRST/LAST). In Firebird 1.5 they
appeared at the tail end (unless etc.)
It's not a problem, it's a solution :-)
And you can always override the placement in your ORDER BY clause.
See http://www.firebirdsql.org/manual/nullguide-sorts.html
Hope this helps,
Paul Vinkenoog
> I don't know it is if the bank or the access component, IBO, but inI guess you mean: before updating to Firebird 2?
> it consults them that I accomplish for a field that has null, I
> register them with null they appear first, before updating it was
> not like this.
That's right: in Firebird 2 nulls appear at the "smallest" end of the
sort (unless overridden by NULLS FIRST/LAST). In Firebird 1.5 they
appeared at the tail end (unless etc.)
It's not a problem, it's a solution :-)
And you can always override the placement in your ORDER BY clause.
See http://www.firebirdsql.org/manual/nullguide-sorts.html
Hope this helps,
Paul Vinkenoog