Page 1 of 1

support for function returning RECORD datatype? output parameters in 2.10?

Posted: Wed 06 Apr 2005 17:57
by andrew macleod
I have a plpgsql function (stored procedure) that returns a single row as a RECORD return type. I do this because I need to return multiple scalar values.

Does PostgreSQLDirect .NET support this? Is there an example of how to parse the elements in the record?

Also, I am interested to note that version 2.10 supports "output parameters". What kind of output parameters? Is there any documentaion on this?

Thanks,

Andrew.

Re: support for function returning RECORD datatype? output parameters in 2.10?

Posted: Thu 07 Apr 2005 07:49
by Yuri
andrew macleod wrote: I have a plpgsql function (stored procedure) that returns a single row as a RECORD return type. I do this because I need to return multiple scalar values.
Does PostgreSQLDirect .NET support this? Is there an example of how to parse the elements in the record?
PostgreSQLDirect .NET supports composite types result set in stored procedures. To see examples you should install Trial version of the provider.
andrew macleod wrote:Also, I am interested to note that version 2.10 supports "output parameters". What kind of output parameters?
To obtain a query result through parameters ReturnValue direction is used.
Please refer to our documentation 'Using parameters' article for detailed information about parameters.