JDBC and composite types

From: Marcin Gala <mailing(at)siec(dot)mine(dot)nu>
To: Postgres jdbc mailing list <pgsql-jdbc(at)postgresql(dot)org>
Subject: JDBC and composite types
Date: 2007-05-19 11:23:35
Message-ID: 464EDE37.8060201@siec.mine.nu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Could anyone tell me, how to read table's columns that are of composite
type? I was trying to use getObject with different types of casting,
however nothing worked :( Also getString doesn't give me a string
representation of type...

My type is:

CREATE TYPE forwarding_number AS
(always number_type,
busy number_type,
"notResponding" number_type,
"notLogged" number_type);

I'm trying to get data from table X where column y is of type
forwarding_number.

Marcin

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-05-21 15:35:11 Re: JDBC and composite types
Previous Message Vincent Lasmarias 2007-05-17 22:33:13 Insert (or update) to a partitioned table returns 0 rows updated