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.
support for function returning RECORD datatype? output parameters in 2.10?
Re: support for function returning RECORD datatype? output parameters in 2.10?
PostgreSQLDirect .NET supports composite types result set in stored procedures. To see examples you should install Trial version of the provider.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?
To obtain a query result through parameters ReturnValue direction is used.andrew macleod wrote:Also, I am interested to note that version 2.10 supports "output parameters". What kind of output parameters?
Please refer to our documentation 'Using parameters' article for detailed information about parameters.