"Andrus" <[EMAIL PROTECTED]> writes: > Why postgres 8.1.3 changes order ? > How to preserve order in newr without adding extra field to report table ?
You are never guaranteed any order in a result set unless you use ORDER BY in the query. Because PG treats UPDATE as DELETE + INSERT, the table ordering changes all the time. -Doug ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
