Re: Returning multiple columns with a function??

On Monday, December 16, 2002, at 05:48  PM, Joshua D. Drake wrote:
> 
> 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
>
> -- 
> CommandPrompt	- http://www.commandprompt.com	
>        +1.503.222-2783          
>
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org