PROPOSAL FE/BE extension to handle IN/OUT parameters

The current situation with IN/OUT parameters requires that  
considerable juggling is required on the client end to not pass the  
OUT parameters in the query. This could be alleviated by adding two  
messages for stored procedure calls
1) PrepareCall which sent the types, and direction of the parameters
2) BindCall which sends the binds the parameters to the above

While I have this working with the jdbc driver, the problem I foresee  
is that when we do finally implement something like what we have  
above. The current driver will be quite difficult to maintain.

Additionally it will be difficult with the current scheme to return  
out parameters and a result set.

Is it  possible to get this into 8.1, or is this a total non-starter



Dave Cramer
davec@postgresintl.com
www.postgresintl.com
ICQ #14675561
jabber davecramer@jabber.org
ph (519 939 0336 )