Re: Returning multiple columns with a function?? - Mailing list pgsql-general

On Monday, December 16, 2002, at 05:48  PM, Joshua D. Drake wrote:
> <snip>
> But something like this fails:
>
> CREATE OR REPLACE FUNCTION test_multiple () RETURNS SETOF text AS
> 'SELECT ''a'', ''b''' LANGUAGE 'SQL';
> ERROR:  function declared to return text returns multiple columns in
> final SELECT

I think you want:  RETURNS SETOF record as 'select ...'

eric

>
> What are we missing?
>
> Sincerley,
>
> Joshua Drake
>
> --
> <COMPANY>CommandPrompt    - http://www.commandprompt.com    </COMPANY>
> <CONTACT>       <PHONE>+1.503.222-2783</PHONE>          </CONTACT>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org