Bradley Kieser <[EMAIL PROTECTED]> writes:
> When I run it, it returns 36 rows.

> Now, if I cut and paste simply the SELECT part and run it, I get the 
> correct number of rows, 170.

If you can reproduce this on something more recent than 7.1, I'd
appreciate seeing a complete (self-contained) example.  I recall having
seen some problems like this with INTERSECT/EXCEPT queries, but not
with plain inner joins ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to