RE: count(*) from view?? - Mailing list pgsql-general

From Sean Carmody
Subject RE: count(*) from view??
Date
Msg-id 00b001c01c3a$d7d64a80$0401a8c0@newton
Whole thread Raw
In response to count(*) from view??  (Greg Brzezinski <gregb@amg.gda.pl>)
List pgsql-general
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--
>
>

pgsql-general by date:

Previous
From: "Sean Carmody"
Date:
Subject: RE: count(*) from view??
Next
From: Barry Lind
Date:
Subject: problem with LIKE and '/%'