| 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: | Whole Thread | Raw Message | 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 |