Postgres Pro
Downloads
Home   >   mailing lists

Re: Datatype of domains not reported correctly. - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: Datatype of domains not reported correctly.
Date
Msg-id h5798d$b0j$1@ger.gmane.org
Whole thread Raw
In response to Re: Datatype of domains not reported correctly.  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view 
Kris Jurka wrote on 03.08.2009 19:44:
> DISTINCT is the JDBC equivalent term for domains.
>
> See Chapter 16 if the JDBC4 spec.
>
> DISTINCT type - a user-defined type based on a built-in type; for
> example: CREATE TYPE MONEY AS NUMERIC(10,2) FINAL
>
> So I believe we're doing the right thing here, although our support for
> DISTINCT elsewhere is probably lacking.

Thanks for the detailed answer. I have to admit that I didn't check the JDBC spec completely.

If the specs require this, I can live with it - although I think the spec is "wrong" here ;)

Regards
Thomas

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Datatype of domains not reported correctly.
Next
From: Michael Schwipps
Date:
Subject: float4 or real in function parameter -> PSQLException: ERROR function in_test4(double precision) does not exist