2010/8/19 Tom Lane <t...@sss.pgh.pa.us>: >> 2010/8/18 Horváth Imre <horvath.i...@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...@gmail.com / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
