PL/pgSQL question
| От | Ycrux |
|---|---|
| Тема | PL/pgSQL question |
| Дата | |
| Msg-id | 4410B78E.2060903@club-internet.fr обсуждение исходный текст |
| Ответы |
Re: PL/pgSQL question
|
| Список | pgsql-general |
Hi All!
I'm trying to get working the below PL/pgSQL function without sucess.
The function is correctly created, but when I tested it i got:
# SELECT grantAccess('sara', 'sarapass');
ERROR: set-valued function called in context that cannot accept a set
CONTEXT: PL/pgSQL function "grantaccess" line 10 at return next
veillewm=#
What I'm missing?
Thank in advance
Younes
----------------- CODE BEGIN --------------------------
CREATE FUNCTION grantAccess(text,text) RETURNS SETOF users AS '
DECLARE
userlogin ALIAS FOR $1;
userpasswd ALIAS FOR $2;
row users%ROWTYPE;
BEGIN
FOR row IN SELECT user_id FROM users WHERE user_login = userlogin
AND user_passwd = userpasswd AND user_account = TRUE LOOP
RETURN NEXT row;
END LOOP;
RETURN;
END;
' LANGUAGE 'plpgsql';
----------------- CODE END --------------------------
В списке pgsql-general по дате отправления: