Re: PGpoint and PGcircle both sql type 1111?

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(at)lab(dot)applinet(dot)nl>