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

From Marcin Mazurek
Subject Re: count(*) from view??
Date
Msg-id 20000911083545.C18997@poznan.mtl.pl
Whole thread Raw
In response to count(*) from view??  (Greg Brzezinski <gregb@amg.gda.pl>)
List pgsql-general
Greg Brzezinski (gregb@amg.gda.pl) napisał:
> 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
I've noticed the same.

Marcin Mazurek

--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/

pgsql-general by date:

Previous
From: Zeljko Trogrlic
Date:
Subject: Re: JDBC
Next
From: Marcin Mazurek
Date:
Subject: Re: ecpg