On Jul 2, 2006, at 10:24 AM, Coda Hale wrote:
This is not particularly friendly behavior, but the buck for this can
be passed on to the SQL standard: if you want an order, specify an
order. Otherwise, don't expect anything.
Does this seem like a valid tradeoff to everyone?
I think it's best that way. Even on DBs that default to order by id,
that order can be less meaningful than you'd expect. Some approaches
to scaling involve allocating blocks of primary keys to separate DB
servers, so the id order may not correspond to global creation order.
--
Josh Susser
http://blog.hasmanythrough.com
_______________________________________________
Rails-core mailing list
Rails-core@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails-core
