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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
