Re: COPY TABLE TO

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: COPY TABLE TO
Дата
Msg-id
15966.1072105960@sss.pgh.pa.us
Ответ на
COPY TABLE TO (Paul Punett)
Список
Дерево обсуждения
Re: *sigh* Randolf Richardson <rr@8x.ca>
Re: *sigh* Mark Kirkwood <markir@paradise.net.nz>
Re: *sigh* "Simon Riggs" <simon@2ndquadrant.com>
Re: *sigh* Mark Kirkwood <markir@paradise.net.nz>
Re: *sigh* Neil Conway <neilc@samurai.com>
COPY TABLE TO "Paul Punett" <paul.punett@shazamteam.com>
Re: COPY TABLE TO Tom Lane <tgl@sss.pgh.pa.us>
Re: COPY TABLE TO "Jeroen T. Vermeulen" <jtv@xs4all.nl> 
"Paul Punett"  writes:
> I need count as the first record? Any suggestions please ?

SQL does not guarantee any particular ordering of rows in a table.
You cannot do what you're doing and expect it to be reliable.

You could do something like this: add a sequence-number column to your
table and then do "SELECT ... ORDER BY seqno" to extract the data in
a controlled order.
		regards, tom lane
В списке pgsql-hackers по дате отправления
Предыдущее
От: Tom Lane
Дата:
Следующее
От: Marc G. Fournier
Дата:
FAQ