Re: IN/OUT parameters

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pg(at)fastcrypt(dot)com, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: IN/OUT parameters
Date: 2005-05-24 23:17:32
Message-ID: 200505241617.33026.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

People:

OK, found it in SQL99:

<SQL parameter declaration> ::=
[ <parameter mode> ] [ <SQL parameter name> ] <parameter type> [ RESULT ]
<parameter mode> ::=
IN
| OUT
| INOUT

... so this is something we need to support, apparently both for Functions and
Procedures (when we get the latter), in the backend, not just JDBC. As you
can imagine, though, SQL03 does nothing to clarify calling rules for IN/OUT
params.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-05-25 01:28:46 Re: Speeding up the Postgres lexer
Previous Message Junaili Lie 2005-05-24 21:38:26 Re: postmaster.pid disappeared

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-05-25 06:25:48 Re: Translation update: pl_PL
Previous Message hiuguis 2005-05-24 21:10:45 Problem catching multiple values