Functions returning complex types. - Mailing list pgsql-hackers

From Thomas Hallgren
Subject Functions returning complex types.
Date
Msg-id bv3g1v$s6h$1@news.hub.org
Whole thread Raw
Responses Re: Functions returning complex types.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I'm trying to use a function that returns a complex type. I have no problem
creating the function but when I try to use it I get the message:

ERROR:  function in FROM has unsupported return type

Apparently, this message stems from the parser. Changing the function so
that it returns a SETOF the same complex type works fine.

Is this the expected behavior? Is SETOF a requirement when using complex
types?

Regards,

- thomas




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: returning PGresult as xml
Next
From: Tom Lane
Date:
Subject: Re: what does it mean