Received: from antrim.com (antrim.antrim.com [209.0.20.210])
	by hub.org (8.9.1/8.9.1) with ESMTP id BAA05593
	for <pgsql-interfaces@postgresql.org>;
	Sat, 26 Dec 1998 01:42:59 -0500 (EST) (envelope-from ssm@antrim.com)
Received: from antrim.com (ssm-home.antrim.com [192.168.2.22])
	by antrim.com (8.8.8/8.8.8-antrim-server) with ESMTP id WAA26323;
	Fri, 25 Dec 1998 22:42:27 -0800 (PST)
Sender: ssm@antrim.com
Message-ID: <36848562.83920B1D@antrim.com>
Date: Fri, 25 Dec 1998 22:42:42 -0800
From: Shankha Mitra <ssm@antrim.com>
Organization: Antrim Design Systems
X-Mailer: Mozilla 4.04 [en] (X11; I; SunOS 5.6 i86pc)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC ResultSetMetaData.getColumnType and getColumnTypeName work
	properly?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

If I create a table thus:

CREATE TABLE title (
	title		text	NOT NULL,
	editions	int4[]
);

and through the JDBC ResultMetaData.getColumnType() interface try to get
the
type of the 'editions' column, I get the value sql.Types.OTHER.  I would
have
guessed it would have been Types.ARRAY.  Am I missing something?

Also getColumnTypeName() returns _int4; is that correct?

Shankha Mitra


As an aside, I decided to print out the values of all the JDBC types and
I get:
ARRAY=2003
BIGINT=-5
BINARY=-2
BIT=-7
BLOB=2004
CHAR=1
CLOB=2005
DATE=91
DECIMAL=3
DISTINCT=2001
DOUBLE=8
FLOAT=6
INTEGER=4
JAVA_OBJECT=2000
LONGVARBINARY=-4
LONGVARCHAR=-1
NULL=0
NUMERIC=2
OTHER=1111
REAL=7
REF=2006
SMALLINT=5
STRUCT=2002
TIME=92
TIMESTAMP=93
TINYINT=-6
VARBINARY=-3
VARCHAR=12