Re: Alter Table Command Rearranges Rows

On Fri, Sep 17, 2010 at 4:32 PM, Michael Glaesemann
<grzm(at)seespotcode(dot)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(dot)broersma(at)gmail(dot)com> wrote:
> On Fri, Sep 17, 2010 at 1:32 PM, Michael Glaesemann
> <grzm(at)seespotcode(dot)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