Re: Select query order

On Wed, Mar 24, 2010 at 8:06 AM, Krithinarayanan Ganesh Kumar
 wrote:
> 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 ? 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.

Unless you have stored something in the table that correlates with the
order of insertion, I don't know of a way to get at the insertion
order as this information is not tracked by Postgresql.

Sean