Re: plpgsql out parameter with select into - Mailing list pgsql-sql

From Tom Lane
Subject Re: plpgsql out parameter with select into
Date
Msg-id 14560.1282169398@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql out parameter with select into  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: plpgsql out parameter with select into
List pgsql-sql
> 2010/8/18 Horv�th Imre <horvath.imre@blemidon.hu>:
>> It don't work...

A function returning a scalar type cannot control the column name
assigned to the scalar in the calling query.  To do that, you need to
return a composite type, which means there need to be at least two OUT
parameters if you're trying to do it via OUT-parameter names.
        regards, tom lane


pgsql-sql by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: plpgsql out parameter with select into
Next
From: Mindtonic
Date:
Subject: Windowed Postgres Query