If I'll make my functions like this:

create function test( out a text, out b text) returns setof record ...

it works well.
but if i have just one column in returned recordset, I cannot:
create function test( out a text ) returns setof record ...
shows:
ERROR:  function result type must be text because of OUT parameters

it's bad because I can't have the column names the way I want it to be
named! (well, I could, using custom datatype, but it's besides the
point.

is there any particular reason why returning single-column "setof
record" is not allowed?

Best regards,

depesz

-- 
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to