| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Paul Punett" <paul(dot)punett(at)shazamteam(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: COPY TABLE TO |
| Date: | 2003-12-22 15:12:40 |
| Message-ID: | 15966.1072105960@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Paul Punett" <paul(dot)punett(at)shazamteam(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2003-12-22 15:20:13 | Re: [HACKERS] Current Win32 port status |
| Previous Message | Tom Lane | 2003-12-22 15:02:47 | Re: [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE r ... |