Re: SQueryTest

> Thanks for that. I suspect that PostgreSQL is the only database to 
> sort Nulls last, just like it is the only one to convert to lower 
> case. 

Well, that would be too good :)

in fact SQL99 introduces 'NULLS FIRST' and 'NULLS LAST' synthax. Of
course, not all databases implement it.

- MSSqlServer does not, and it choosed to put Nulls first.

- IBM DB2 UDB does not, and it choosed to put Nulls last (doc says
"Ordering is performed in accordance with the comparison rules described
in "Language Elements". The null value is higher than all other
values.")

- Oracle does implement NULLS FIRST/LAST and defaults to NULLS FIRST

- Postgresql (8.3) does implement NULLS FIRST/LAST and defaults to NULLS
LAST

etc. Not to speak about callation order, depending on the locale a
database uses...

So as a rule, one should be very careful with sort order, nulls and
locales !

But that said, it is fixed in the test.

Franck



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/SimpleORM/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected] 
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/