Re: Alter Table Command Rearranges Rows

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Alter Table Command Rearranges Rows
Date: 2010-09-17 20:23:45
Message-ID: AANLkTik0r_zr_oQCWJm47TDTDd9FmP2Jrrd_XZFUQKHF@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 17, 2010 at 4:12 PM, Carlos Mennens
<carlos(dot)mennens(at)gmail(dot)com> wrote:
> Thanks for any assistance or clarification.
>

Rows in SQL are unordered. If you want an ordering, specify one on your SELECT.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-09-17 20:28:53 Re: missing chunk number 497 for toast value 504723663
Previous Message Carlos Mennens 2010-09-17 20:12:32 Alter Table Command Rearranges Rows