Re: plpgsql out parameter with select into

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Horváth Imre <horvath(dot)imre(at)blemidon(dot)hu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql out parameter with select into
Date: 2010-08-18 22:09:58
Message-ID: 14560.1282169398@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 2010/8/18 Horvth Imre <horvath(dot)imre(at)blemidon(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sergey Konoplev 2010-08-18 22:18:11 Re: plpgsql out parameter with select into
Previous Message Sergey Konoplev 2010-08-18 21:58:14 Re: plpgsql out parameter with select into