Postgres Pro
Downloads
Home   >   mailing lists

Re: PG 7.1: VIEW returns fewer rows than equivalent select - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PG 7.1: VIEW returns fewer rows than equivalent select
Date
Msg-id 28516.1027352142@sss.pgh.pa.us
Whole thread Raw
In response to PG 7.1: VIEW returns fewer rows than equivalent select  (Bradley Kieser <brad@kieser.net>)
List pgsql-bugs
Tree view 
Bradley Kieser <brad@kieser.net> 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

pgsql-bugs by date:

Previous
From: Bradley Kieser
Date:
Subject: PG 7.1: VIEW returns fewer rows than equivalent select
Next
From: "Daniel Alvarez"
Date:
Subject: pg_ctl -w option does not behave as documented