Re: [GENERAL] duplicate rows in query

2009-05-23 Thread Alban Hertroys
On May 22, 2009, at 9:41 PM, Mark Watson wrote: Hello all, I have a perplexing problem which I cannot figure out. I have a somewhat complex query that is returning two identical rows, where only one row exists in the table. If I run a simpler query, I receive the one row as desired. ...

[GENERAL] duplicate rows in query

2009-05-22 Thread Mark Watson
Hello all, I have a perplexing problem which I cannot figure out. I have a somewhat complex query that is returning two identical rows, where only one row exists in the table. If I run a simpler query, I receive the one row as desired. This is on a windows vista development machine with Postgres 8.