Select query order
От
Krithinarayanan Ganesh Kumar
Тема
Select query order
Дата
Msg-id
61940faf1003240506n5154f4fr81f7e9d983f6761d@mail.gmail.com
Список
Дерево обсуждения
Re: Select query order Jasen Betts <jasen@xnet.co.nz>
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.
I tried row_number() over () Window function but not of use
Thanks & Regards
Krithi
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.
I tried row_number() over () Window function but not of use
Thanks & Regards
Krithi
В списке pgsql-novice по дате отправления
