I've now tested your problem on the 7.0.2 and the problem doesn't
seem to arise there, so it looks as though the problems with the
rule rewriter have been fixed. Maybe you should try upgrading.
Regards,
Sean.
> -----Original Message-----
> From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
> Behalf Of Greg Brzezinski
> Sent: Friday, 8 September 2000 11:32 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] count(*) from view??
>
>
> create table test (id int, user_name char(30));
> insert into test values (1, 'John');
> insert into test values (2, 'George');
>
> create view v_test as select * from test where user_name = 'John';
>
> select count(*) from v_test;
> count
> -------
> 2
> (1 row) Why?...Should returns 1
>
> select count(*) from test where user_name = 'John';
> count
> -------
> 1
> (1 row)
>
> --Greg--
>
>