count(*) from view??
От | Greg Brzezinski |
---|---|
Тема | count(*) from view?? |
Дата | |
Msg-id | 20000908.12322119@gregb.amg.gda.pl обсуждение исходный текст |
Ответы |
Re: count(*) from view??
Re: count(*) from view?? Re: count(*) from view?? RE: count(*) from view?? RE: count(*) from view?? |
Список | pgsql-general |
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 по дате отправления: