Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group