Обсуждение: Where is the problem?

Поиск
Список
Период
Сортировка

Where is the problem?

От
Juan Carlos Perez Vazquez
Дата:
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