Open main menu

CDOT Wiki β

Changes

Default orderBy research 2/17/2011

123 bytes added, 15:58, 17 February 2011
no edit summary
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
 
Solution: Every time we have ORDER BY we specify '''nulls first''' (this option is supported in PostgreSQL 8.3 and later)
1
edit