Re: PL/pgSQL question - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/pgSQL question
Date
Msg-id 28877.1141950352@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL question  (Ycrux <ycrux@club-internet.fr>)
List pgsql-general
Ycrux <ycrux@club-internet.fr> writes:
> # SELECT grantAccess('sara', 'sarapass');
> ERROR:  set-valued function called in context that cannot accept a set

You need to do "SELECT * FROM grantAccess(...)".  This is a plpgsql
implementation restriction that we'll probably try to fix someday,
although there's also a school of thought that says that set-returning
functions in the SELECT targetlist are a bad idea and should be phased
out.

            regards, tom lane

pgsql-general by date:

Previous
From: "Mongi LASSOUED"
Date:
Subject: posgresql server connection
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: majordomo unmaintained, postmaster emails ignored?