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

[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.

[Yuri]

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.

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.