calling function

Hi,
I have a little trouble. I'm newbie in postgresql.

Consider this function example:

create or replace function testcall(int4,varchar,bool,int2) return setof record as '
declare
r record;
a int4;
b varchar;
c bool;
d int2;
begin
a=$1;
b=$2;
c=$3;
d=$4;

for r in select * from "T_Customer" loop
return next r;
end loop;

return r;
end;'
language 'plpgsql'

when i tried to call it using:
select * from testcall(12,'ABCD',true,20000);

it says:
ERROR: function testcall(integer, "unknown", boolean, integer) does not exist

then I tried to change to:
select * from testcall(12,varchar'ABCD',true,20000);

it says:
ERROR: function testcall(integer, character varying, boolean, integer) does not exist

I've tried them using jdbc prepared statement and callable statement (both with/without parameters), but the result is the same.
what should i do?

Thanks

William

Need a new email address that people can remember
Check out the new EudoraMail at
http://www.eudoramail.com