Re: [GENERAL] recursive query returning extra rows in 8.4

2013-10-15 Thread Chris
On 16/10/13 01:56, Tom Lane wrote: David Johnston writes: chris smith-9 wrote 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). Likel

Re: [GENERAL] recursive query returning extra rows in 8.4

2013-10-15 Thread Tom Lane
David Johnston writes: > chris smith-9 wrote >> 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). > Likely this is a bug that was f

Re: [GENERAL] recursive query returning extra rows in 8.4

2013-10-15 Thread David Johnston
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 iterati

[GENERAL] recursive query returning extra rows in 8.4

2013-10-14 Thread Chris
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). Just wondering if anyone had thoughts on why, and/or how to remove the dupli