Hi,
Can anyone please tell me whether this is a bug or not?
I used the following SQL to create my table and view with some data.
=======================
create table tbl (no int, cnt int);
create view tbl_view as
select no, count(cnt) as count
from tbl
group by no
having count(cnt) > 2;
insert into tbl values(1, 1);
insert into tbl values(1, 2);
insert into tbl values(1, 3);
insert into tbl values(1, 4);
insert into tbl values(2, 1);
insert into tbl values(2, 2);
insert into tbl values(2, 3);
=======================
Here is soem SQL I issued; first one looks fine to me, but the second
one is weird.
=======================
db=> select * from tbl_view;
no | count
----+-------
1 | 4
2 | 3
(2 rows)
db=> select * from tbl_view where count > 5;
no | count
----+-------
1 | 4
2 | 3
(2 rows)
db2=>
=======================
Thanx
LM.Liu
