Обсуждение: PGpoint and PGcircle both sql type 1111?

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"? Or, could the
PG extended types be differentiated somehow? (e.g. 1111 and 1112)?

I am using the JBOSS ejb server, which makes use of the column type in
order to figure out what to do with the columns, so it's important to me
that they be differentiated.

If this is easy to do, I may just patch the sources and submit my
changes. But first I'd like to hear if anyone else out there has an
opinion on this matter.

Thanks,
Bryan

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>