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) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general