Re: can plpgsql returns more flexibe value ? - Mailing list pgsql-hackers

From Arnold.Zhu
Subject Re: can plpgsql returns more flexibe value ?
Date
Msg-id 20050122015354.9DB646D98@shaucon.com
Whole thread Raw
In response to can plpgsql returns more flexibe value ?  ("Arnold.Zhu" <joint@shaucon.com>)
Responses Re: can plpgsql returns more flexibe value ?  (Kris Jurka <books@ejurka.com>)
List pgsql-hackers
Hello, Christopher Kings-Lynne


>Yeah, you just make your function return 'SETOF record' and specify the 
>types when you do the select:
>
>select * from func() as (a int, b text);
>
>Chris
>

This is not a good idea when I use C# to program, I want to Fill the resultset
directly into  Dataset, this method will should use more sql to get data,
it lose function's convenience like stored procedure.

Thanks & Regards!         
Arnold.Zhu
2005-01-22





pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: ARC patent
Next
From: Kris Jurka
Date:
Subject: Re: can plpgsql returns more flexibe value ?