2010/8/19 Tom Lane <tgl@sss.pgh.pa.us>:
>> 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.
So we could do either
SELECT funcname INTO varname FROM funcname()
or
SELECT * INTO varname FROM funcname();
or
SELECT funcname() INTO varname
correct?
>
> regards, tom lane
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Sergey Konoplev
Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802
