Where is the problem?

From: Juan Carlos Perez Vazquez <cray2(at)mail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Where is the problem?
Date: 2000-08-26 23:38:00
Message-ID: 381965809.967333080157.JavaMail.root@web307-mc.mail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)mail(dot)com

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

Browse pgsql-hackers by date

  From Date Subject
Next Message David Lloyd-Jones 2000-08-27 08:20:55 Re: How Do You Pronounce "PostgreSQL"?
Previous Message Tom Lane 2000-08-26 23:36:53 UNION JOIN vs UNION SELECT