X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 5C8239DC887
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  7 Feb 2006 07:08:38 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 12060-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  7 Feb 2006 07:08:40 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210])
	by postgresql.org (Postfix) with ESMTP id 7A32F9DC84B
	for <pgsql-sql@postgresql.org>; Tue,  7 Feb 2006 07:08:34 -0400 (AST)
Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1])
	by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k17CBXOp006460;
	Tue, 7 Feb 2006 14:11:33 +0200
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id
	k17CBXig006456; Tue, 7 Feb 2006 14:11:33 +0200
Date: Tue, 7 Feb 2006 14:11:33 +0200 (EET)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Richard Huxton <dev@archonet.com>
cc: padmanabha konkodi <konkodi221@rediffmail.com>, <pgsql-sql@postgresql.org>
Subject: Re: passing array to database function
In-Reply-To: <43E87C0A.9030304@archonet.com>
Message-ID: <Pine.LNX.4.44.0602071403550.6338-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-7
Content-Transfer-Encoding: 8BIT
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.107 required=5 tests=[AWL=0.107]
X-Spam-Score: 0.107
X-Spam-Level: 
X-Archive-Number: 200602/58
X-Sequence-Number: 24068

O Richard Huxton έγραψε στις Feb 7, 2006 :

> padmanabha konkodi wrote:
> > Β hi everybody,
> > 
> > i want to pass Integer array to database function from java
> > precompiled statement.
> > 
> > java gives java.sql.Array interface but i dont know which
> > implementing class i have to use in postgre
> 
> I don't really "do" java, but have you tried an array of integers for 
> your PostgreSQL function? What happened?

The correct list is -jdbc.
Theoritically you would have to write your own implementation
of java.sql.Array.
Practically build a String with the contents you want
e.g.
'{1,2,3,4}' 
for a int[] array, and your done.

> 
> 

-- 
-Achilleus