Is this a bug?

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