Re: [SQL] 9.0rc1 - query of view produces unexpected results

2010-09-14 Thread Nathan Grange
Doh!! Files attached this time. On 09/11/2010 07:31 PM, Nathan Grange wrote: Hello list, I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpected results when i query a specific view. I can only reproduce the unexpected results with a very

Re: [SQL] 9.0rc1 - query of view produces unexpected results

2010-09-14 Thread Tom Lane
Nathan Grange nath...@actarg.com writes: Or if this is a bug with 9.0, what actions do I take to make the PostgreSQL team awares? I think you already did ;-) regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your

Re: [SQL] 9.0rc1 - query of view produces unexpected results

2010-09-13 Thread Alvaro Herrera
Excerpts from Nathan Grange's message of sáb sep 11 21:31:04 -0400 2010: Hello list, I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpected results when i query a specific view. Included are a buildDemo.sql file that will create the

[SQL] 9.0rc1 - query of view produces unexpected results

2010-09-11 Thread Nathan Grange
Hello list, I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpected results when i query a specific view. I can only reproduce the unexpected results with a very specific set of tables, views, and relationships. The bad results are only