Arrays, JDBC and Postgresql Functions

From: Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz>
To: Postgresql General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Arrays, JDBC and Postgresql Functions
Date: 2003-05-08 22:39:38
Message-ID: 1052433577.4920.14.camel@atlas.sol.deeper.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,
I was just reading the docs. And it's possible to have an array of
data-type in Postgresql, that's all good. However, I was wondering if,
1) I can pass an array into a function?
2) easily iterate through it's elements?
3) Using JDBC and the Postgresql driver pass a Vector of say, BIGINTs to
the function?

Why do I want to do this? Because I could the database perform a
majority some work server side, with a small network request.

Like, an order is consigned to a customer, however, the units on the
order are variable and once approved, I could call the function like,
fn_unit_consign_for_order( BIGINT, BIGINT[] ) where the $1 is the order
Id and BIGINT[] is the units from that order to consign.

Can anybody help thanks.

Hadley

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-05-08 22:48:16 Re: Error installing postgresql-7.3.2 (fixed, but Q remains...)
Previous Message scott.marlowe 2003-05-08 22:39:15 Re: Error executing dbcreate