Re: recursive query returning extra rows in 8.4

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.