From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Select query order |
Date: | 2010-03-25 08:57:53 |
Message-ID: | hof8ih$ip4$2@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 2010-03-24, Krithinarayanan Ganesh Kumar <krithinarayanan(at)gmail(dot)com> wrote:
> --000325560bde5e345c04828ac143
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi All,
>
> I am aware that Select query does not guarantee the order of the rows
> returned ( The rows are returned in whatever order the system finds fastest
> to produce).
>
> Is there any way to SELECT the rows in the same order of insertion ?
only if the records contain that information.
> The
> problem is there is no Primary Key in the table, I am having only a
> composite key. So I cannot ORDER BY pk also.
You can order by the primary key, but from your description it's unlikely
to give insertion order.
From | Date | Subject | |
---|---|---|---|
Next Message | dipti shah | 2010-03-25 09:07:45 | Get the list of permissions/privileges on schema |
Previous Message | Zdravko Balorda | 2010-03-24 14:44:31 | Table inheritance |