stored proc help
От | Jason Tesser |
---|---|
Тема | stored proc help |
Дата | |
Msg-id | AA9E9C9ACAFCA545A33A9F6E1E88353E06968E@titus.nmi.northlandministries.org обсуждение исходный текст |
Ответы |
Re: stored proc help
|
Список | pgsql-general |
I have the following store dproc but when I run it I am getting the error
ERROR: invalid input syntax for integer: "(1)"
CONTEXT: PL/pgSQL function "irispermissionget" line 9 at return next
What am I doing wrong?
CREATE OR REPLACE FUNCTION "public"."irispermissionget" (username varchar, pass varchar) RETURNS SETOF integer AS
$body$
declare
returnRec Record;
begin
for returnRec in select cast(irisuserpermission.permissionid as integer)
from irisuserpermission INNER JOIN public.irisuser ON (public.irisuserpermission.irisuserid = public.irisuser.id)
where irisuser.user = username and irisuser.password = pass
loop
return next returnRec;
end loop;
return;
end;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
В списке pgsql-general по дате отправления: