On Fri, Sep 17, 2010 at 4:32 PM, Michael Glaesemann
<grzm@seespotcode.net> 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@gmail.com> wrote:
> On Fri, Sep 17, 2010 at 1:32 PM, Michael Glaesemann
> <grzm@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.
MySQL does but I am fine with just running the ORDER BY command when I
use SELECT.
-Carlos