Stored Procedure Parameters

rwalrond · Post by **rwalrond** » Fri 15 Apr 2005 22:59

Postgre functions is limited to 32 arguments. The "recommendation" is to use function with composite type. 
for example 
CREATE FUNCTION double_sal(emp) RETURNS numeric AS $$ 
SELECT $1.sal * 2 AS salary; 
$$ LANGUAGE SQL;

where emp is table (or can be a view).
Does the latest version of PostgreSQLDirect.NET allows this usage?

Yuri · Post by **Yuri** » Mon 18 Apr 2005 07:04

A possibility to pass record types through parameters will be added at the next version of the provider.

Guest · Post by **Guest** » Mon 30 May 2005 15:51

A possibility to pass record types through parameters will be added at the next version of the provider.

Has it been added with the May 30th release? This is the feature that is preventing me from purchasing your product.

Yuri · Post by **Yuri** » Fri 03 Jun 2005 13:51

This feature will be add only in the 2.11.* version. We are planning to release it in a month.

rwalrond · Post by **rwalrond** » Mon 04 Jul 2005 16:00

This feature will be add only in the 2.11.* version. We are planning to release it in a month.

Has it been added?

Yuri · Post by **Yuri** » Tue 05 Jul 2005 06:20

This functionality will be added in the next PostgreSQLDirect.NET bulds.

Riaan van der Westhuizen · Post by **Riaan van der Westhuizen** » Thu 14 Jul 2005 11:31

Yuri · Post by **Yuri** » Fri 22 Jul 2005 09:19

Once we add this functionality we'll let you know.

Guest · Post by **Guest** » Mon 12 Sep 2005 05:09

Yuri,

Any updates on this?

Thanks.

Yuri · Post by **Yuri** » Mon 12 Sep 2005 07:06

We are planning to release new version of PostgreSQLSDirect .NET in a week. We will add support of row types in new version.

Guest · Post by **Guest** » Mon 26 Sep 2005 08:08

Yuri,

Please be more specific about a timeline. We are at risk of missing our deadlines when Core Lab slips.

Devart Forums