Re: Weird issues when reading UDT from stored function - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Weird issues when reading UDT from stored function
Date
Msg-id 4D2BAECB.7040108@opencloud.com
Whole thread Raw
In response to Re: Weird issues when reading UDT from stored function  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
On 11/01/11 13:24, Oliver Jowett wrote:
> On 11/01/11 12:06, Lukas Eder wrote:

>> ====================================
>> Output:
>> # of columns: 6
>> ("(""Parliament Hill"",77)",NW31A9)
>>
>> Why are there 6 columns? And why is the UDT incorrectly fetched (many
>> fields are missing)
>
> Looks to me like you're getting each field of the UDT as a separate
> column. You printed only the first column i.e. the 'street' part.

Oops, looking closer I see what you mean, that's actually 2 columns of
the surrounding type - street + zip? What are the values of the other 5
columns reported by the driver?

A loglevel=2 trace would still be useful here.

Oliver

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Weird issues when reading UDT from stored function
Next
From: Lukas Eder
Date:
Subject: Fwd: Weird issues when reading UDT from stored function