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