Thread: DatabaseMetaData and numeric array

DatabaseMetaData and numeric array

From
abyss
Date:
Hi! Is there a way to get proper precision and scale of numeric array?
 
eg:
create table public.test (
testnum numeric(18,4)[]
);
 
DatabaseMetaData.getPrecision and getScale always return 0...
 
Thanks!

Re: DatabaseMetaData and numeric array

From
Kris Jurka
Date:

On Mon, 17 Dec 2007, abyss wrote:

> Hi! Is there a way to get proper precision and scale of numeric array?
>

Getting metadata on array types doesn't work at the moment.  This is a
known issue as reported here.

http://archives.postgresql.org/pgsql-jdbc/2007-11/msg00069.php

Kris Jurka