Where is the problem? - Mailing list pgsql-hackers

From Juan Carlos Perez Vazquez
Subject Where is the problem?
Date
Msg-id 381965809.967333080157.JavaMail.root@web307-mc.mail.com
Whole thread Raw
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Critical server is down, user needs help
Next
From: "David Lloyd-Jones"
Date:
Subject: Re: How Do You Pronounce "PostgreSQL"?