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 ---------------------------(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