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

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

Postby andrew macleod » Wed 06 Apr 2005 17:57

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.
andrew macleod
 

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

Postby Yuri » Thu 07 Apr 2005 07:49

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.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07


Return to dotConnect for PostgreSQL