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)