Postgres Pro
Downloads
Home   >   mailing lists

JDBC and composite types - Mailing list pgsql-jdbc

From Marcin Gala
Subject JDBC and composite types
Date
Msg-id 464EDE37.8060201@siec.mine.nu
Whole thread Raw
Responses Re: JDBC and composite types
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Vincent Lasmarias
Date:
Subject: Insert (or update) to a partitioned table returns 0 rows updated
Next
From: Kris Jurka
Date:
Subject: Re: JDBC and composite types