On Fri, Sep 17, 2010 at 1:32 PM, Michael Glaesemann <g...@seespotcode.net> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general