On Sat, 22 Jan 2005, Arnold.Zhu wrote:
> >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);
> >
>
> 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.
>
Perhaps you should look into the refcursor type, which will allow you to
return anything you want without specifying it. You can't do things like
a join between to refcursor outputs, but it does allow for more return
flexibility.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
