| Lists: | pgsql-jdbc |
|---|
| From: | "Mohammad Altaf" <altafmo(at)FusionTech(dot)Com> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Out parameter support in PostgreSQL |
| Date: | 2004-12-30 11:06:47 |
| Message-ID: | 73A2F23AAEB7C641BF7FDD5D1973A1A3EB0645@fusionmail.fusion-net.fusiontech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
Hi,
Can anybody tell me if the JDBC Driver for postgreSQL 8.0 rc1 has the
support for passing arrays as in/out parameters to the procedures or
not???? Or if the postgreSQL supports passing arrays as in/out
parameters or not. If anybody can give me the example, I'll be thankful.
Thanks in advance.
Altaf Malik
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Mohammad Altaf <altafmo(at)fusiontech(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Out parameter support in PostgreSQL |
| Date: | 2005-01-05 04:48:38 |
| Message-ID: | Pine.BSO.4.56.0501042346010.8811@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
On Thu, 30 Dec 2004, Mohammad Altaf wrote:
> Can anybody tell me if the JDBC Driver for postgreSQL 8.0 rc1 has the
> support for passing arrays as in/out parameters to the procedures or
> not???? Or if the postgreSQL supports passing arrays as in/out
> parameters or not. If anybody can give me the example, I'll be thankful.
>
The JDBC driver supports java.sql.Array to pass function parameters and
receive the results. It does require a specific Array implementation and
is subject to the normal function limitation of not supporting output
parameters.
Kris Jurka