On Sat, 30 Aug 2003, Dan Langille wrote:
> Hi folks,
>
> I'm playing with SETOF on functions. But I can't get the return type
> correct. What have I missed? A cast?
>
> CREATE OR REPLACE FUNCTION elementGet (text) RETURNS SETOF
> element_type AS '
>
> select 1,
> \'test\',
> \'F\'
> \'A\',
> FALSE,
> FALSE
> '
> LANGUAGE sql stable;
> ERROR: function declared to return element_type returns "unknown"
> instead of text at column 2
I think you'll need to explicitly make the three text columns text rather
than just a plain literal (so ''test''::text for example)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
