Thread: Create function returning "set"

I have pgadmin 1.4.12 and pgsql 7.3.2
I can't create a function returning a set because
I can't check the corresponding option
I do "create object... -> ...Function -> Properties -> "
and I try to check option called "Returns a Set" but it doesn't seems possible.

For the moment, I have to create my function under "psql".
Moreover, after that, the view under pgadmin of the new function, shows me the
option "Returns a Set" checked !

Is this behaviour normal ?

thanks for your response.

(Sorry for my english...)
tronika@free.fr

> -----Original Message-----
> From: tronika@free.fr [mailto:tronika@free.fr]
> Sent: 15 April 2003 15:26
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Create function returning "set"
>
>
> I have pgadmin 1.4.12 and pgsql 7.3.2
> I can't create a function returning a set because
> I can't check the corresponding option
> I do "create object... -> ...Function -> Properties -> "
> and I try to check option called "Returns a Set" but it
> doesn't seems possible.
>
> For the moment, I have to create my function under "psql".
> Moreover, after that, the view under pgadmin of the new
> function, shows me the
> option "Returns a Set" checked !
>
> Is this behaviour normal ?

Hi,

Yes, this is normal as pgAdmin doesn't currently support the creation of
SRFs unfortunately.

> thanks for your response.
>
> (Sorry for my english...)

Why? What's wrong with it? :-)

Regards, Dave.