"Paul Punett" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html