Re: Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count

In response to Abraham, Danny :
> Any idea?

Apparently no, because nobody can reproduce your problem.
See my other post, supplementary:

test=*# create view view_o as select * from o;
CREATE VIEW
test=*# create or replace function my_count() returns int as $$declare c
int;begin select into c count(1) from view_o where i=2; return c;
end;$$language plpgsql;
CREATE FUNCTION
test=*# select * from my_count();
my_count
----------
1
(1 row)

Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)