PROPOSAL FE/BE extension to handle IN/OUT parameters

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: PROPOSAL FE/BE extension to handle IN/OUT parameters
Date: 2005-06-21 18:38:36
Message-ID: D492C412-3F99-41A2-AC88-3776866D1DBA@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)postgresintl(dot)com
www.postgresintl.com
ICQ #14675561
jabber davecramer(at)jabber(dot)org
ph (519 939 0336 )

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-06-21 18:46:36 Re: Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic
Previous Message Pavel Stehule 2005-06-21 17:51:33 Re: PROPOSAL - User's exception in PL/pgSQL