CREATE FUNCTION CHANGE_PASSWORD (text, text) RETURNS bool AS '
BEGIN
ALTER USER $1 WITH PASSWORD ''$2'';
RETURN ''t'';
END;
' LANGUAGE 'plpgsql';

select CHANGE_PASSWORD('USER','PASS');

this get me "ERROR: parser: parse error at or near "$1"

could I make a function that not returns values?

cray2@mail.com


______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup


Sat, 26 Aug 2000 19:38:00 -0400 (EDT)
Juan Carlos Perez Vazquez <cray2@mail.com>
Where is the problem?