Changes

Jump to: navigation, search

Default orderBy research 2/17/2011

2 bytes added, 13:29, 18 February 2011
no edit summary
And in the MySQL:<br/>
When doing an ORDER BY, '''NULL values''' are presented '''first''' if you do ORDER BY ... ASC ('''default''') and last if you do ORDER BY ... DESC. <br/>
This explains why testUpdates gives the specified message, and I guess we have the same issue when we are trying to read '''without order by''' clause.
<br/>Solution: Every time we have ORDER BY we specify '''nulls first''' (this option is supported in PostgreSQL 8.3 and later).
1
edit

Navigation menu