chris smith-9 wrote > Hi all, > > Using postgres 8.4.13 (latest that redhat provides in rhel6) the query > below returns an extra row compared to running the same thing in later > versions (tried 9.0, 9.1, 9.2 - they don't return the extra row). > > > SELECT * > FROM numbers > ORDER BY iteration, depth; Likely this is a bug that was fixed in one of the five newer 8.4 point releases. You can use "SELECT DISTINCT *" to get rid of the extra data if you choose not to upgrade. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/recursive-query-returning-extra-rows-in-8-4-tp5774573p5774607.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
