On Fri, Sep 17, 2010 at 4:32 PM, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> wrote: > This isn't valid syntax: I believe you issued UPDATE users.... Woops. I did use the UPDATE and not ALTER command. On Fri, Sep 17, 2010 at 4:39 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > 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. MySQL does but I am fine with just running the ORDER BY command when I use SELECT. -Carlos -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
