Hi all
I'm new to PostgreSql
i'm trying to write a simple function
CREATE OR REPLACE FUNCTION insert_tmp_pswd2 (int4, varchar)
RETURNS int4 AS '
DECLARE
tmp VARCHAR;
BEGIN
insert into "ExAfrica".test2 values($1, $2,now());select 1;
END;
'
LANGUAGE 'sql';
i really dont know why he doesnt want to declare new vars...
pls help!
thanks!