On Fri, Nov 09, 2007 at 03:17:53PM +0400, rihad wrote: > >Em Wednesday 07 November 2007 13:54:32 rihad escreveu: > >> > >>May I, as an outsider, comment? :) I really think of ASC NULLS > >>FIRST (and DESC NULLS LAST) as the way to go. Imagine a last_login > >>column that sorts users that have not logged in as the most > >>recently logged in, which is not very intuitive. I vote for > >>sort_nulls_first defaulting to false in order not to break bc. > > > >But then, when ordering by login date, you should use COALESCE and > >infinity for them > >(http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html). > > It's not an easy thing to do with for example Propel 1.2 ORM > (written in PHP): > > $criteria->addDescendingOrderByColumn(myPeer::LAST_LOGIN); // no > place to shove database-specific attributes in. > > which was my main point. If your ORM is broken as above, either fix it or do something that isn't broken. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
