Re: Retrieving field of type bigint[]

From: Rene Pijlman <rpijlman(at)wanadoo(dot)nl>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Retrieving field of type bigint[]
Date: 2001-08-09 08:50:29
Message-ID: 8lj4nto4gaukq8rvmo32g9agusrneaai8d@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello Ravi,

Thank you for the clarification. The best way to handle this
would be with the JDBC methods getArray and setArray.
Unfortunately, these methods are currently not implemented in
the JDBC driver. See also
http://lab.applinet.nl/postgresql-jdbc/ ("Array").

Regards,
René Pijlman

On Thu, 9 Aug 2001 17:28:34 +0900, you wrote:
>Hi René Pijlman,
>
> Thank you for your mail. Sorry for the delayed reply .
> I am giving the details about my application .
>
> > the CREATE TABLE statement used to create this particular
> >table (or a description of the table from psql)
> CREATE TABLE mytable (sno integer UNIQUE, image_ids bigint[]);
>
> >- some data from this table
> The value of one of the row for the image_ids field : {"20", "40"}
>
> I tried to retrieve value of this field using getString(columnName)
>method
>of ResultSet and I was able to do it . I am able to insert the retrieved
>string back in to the
>database without any problem . So my problem is solved from my point of
>view.
>
> Is there anything wrong in what I did ? If it is , please tell me the
>correct way.
>
>Thanks & Regards,
>Ravi

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Denis Bucher 2001-08-09 10:07:41 Re: Bug found in the driver
Previous Message RaviShankar K 2001-08-09 08:29:17 field of type oid