From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | dmp <danap(at)ttc-cmc(dot)net> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Array Char/VarChar Size |
Date: | 2008-02-29 16:59:17 |
Message-ID: | Pine.BSO.4.64.0802291158350.30735@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Wed, 27 Feb 2008, dmp wrote:
> Given a defined table as such:
>
> CREATE TABLE array_types (
>
> data_type_id serial NOT NULL,
> decimal_array decimal(16,2)[] DEFAULT NULL,
> numeric_array numeric(10,2)[] DEFAULT NULL,
> varchar_array varchar(30)[] DEFAULT NULL,
> char_array char(30)[][] DEFAULT NULL,
> PRIMARY KEY (data_type_id)
> );
>
> How do I obtain the precision, decimal places, or character
> sizing information from the database. Notice these are array
> types.
Currently the driver does not return this information, but we've listed it
as an open feature request:
http://pgfoundry.org/tracker/index.php?func=detail&aid=1010248&group_id=1000224&atid=857
Kris Jurka
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2008-02-29 17:09:52 | Re: Bug while retrieving money data type from db |
Previous Message | Daniel Migowski | 2008-02-27 07:57:13 | Re: Fastest way to check aliveness of connection |