On Fri, Sep 17, 2010 at 1:32 PM, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> wrote: > Postgres (nor any other SQL RDBMS) does not guarantee row order unless you specify it with an ORDER BY clause. This is true, but some database will maintain a tables clustering. MS-Access comes to mind. I don't know if MySQL does this also. In PostgreSQL you can issue a periodic cluster command on the primary key. But as mentioned it is a bad practice to rely on the physical ordering of the table. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
