Re: [BUGS] bug in views/aggregates

2000-10-25 Thread Tom Lane
Kovacs Zoltan Sandor <[EMAIL PROTECTED]> writes: > I'm not sure if this is a reported bug or not. SELECT statements with some > aggregates on certain complex views can give terrible results. An example: Aggregates on grouped views do not and cannot work in 7.0 or earlier releases, because the exi

[BUGS] bug in views/aggregates

2000-10-25 Thread Kovacs Zoltan Sandor
I'm not sure if this is a reported bug or not. SELECT statements with some aggregates on certain complex views can give terrible results. An example: CREATE TABLE master ( id int4 not null, no int4 check (no >= 0) default 0, primary key (id, no), started date check ((not started i