Re: PL/PG SQL: select count(*) into from where - does not compute the where cond

In response to Abraham, Danny :
> Instead it returns the full count of the table.
>
> Any idea?

No. Can you show us an example?

test=*# select * from o;
 i
---
 3
 1
 2
(3 rows)

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

In other words: works for me.


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