Re: PGpoint and PGcircle both sql type 1111? - Mailing list pgsql-jdbc

From Rene Pijlman
Subject Re: PGpoint and PGcircle both sql type 1111?
Date
Msg-id hadmptoss1up1q3lcfv9iio7gmq2dm349i@4ax.com
Whole thread Raw
In response to PGpoint and PGcircle both sql type 1111?  (Bryan Field-Elliot <bryan_lists@netmeme.org>)
List pgsql-jdbc
On Mon, 03 Sep 2001 15:03:43 -0600, you wrote:
>I was wondering why it is that both PGpoint and PGcircle return a
>"getColumnType" of 1111?
>Is 1111 an arbirtrary number for "non-JDBC-standard type"?

Yes. This is a comment from the source
(src/interfaces/jdbc/org/postgresql/Field.java):

"This table holds the org.postgresql names for the types
supported. Any types that map to Types.OTHER (eg POINT) don't go
into this table. They default automatically to Types.OTHER"

>Or, could the PG extended types be differentiated somehow?
>(e.g. 1111 and 1112)?

Have you seen this documentation already?
http://www.ca.postgresql.org/users-lounge/docs/7.1/programmer/jdbc-ext.html
("8.6.2. Geometric Data Types").

I haven't used this feature myself, so I'm not sure if the
documentation is of any help regarding your problem.

Regards,
René Pijlman <rene@lab.applinet.nl>

pgsql-jdbc by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: Need help with JDBC driver. Problem, - getExportedKeys=
Next
From: Shanmugasundaram
Date:
Subject: Regarding Error installing jdbc7.0-1.2.jar