Re: can plpgsql returns more flexibe value ?

From: "Arnold(dot)Zhu" <joint(at)shaucon(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: can plpgsql returns more flexibe value ?
Date: 2005-01-22 01:53:37
Message-ID: 20050122015354.9DB646D98@shaucon.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kris Jurka 2005-01-22 03:24:00 Re: can plpgsql returns more flexibe value ?
Previous Message J Roy 2005-01-22 01:43:06 how to set password while loging into database