Re: Weird issues when reading UDT from stored function

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: Weird issues when reading UDT from stored function
Дата
Msg-id 4D2BAECB.7040108@opencloud.com
обсуждение исходный текст
Ответ на Re: Weird issues when reading UDT from stored function  (Oliver Jowett <oliver@opencloud.com>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: Weird issues when reading UDT from stored function
Следующее
От: Lukas Eder
Дата:
Сообщение: Fwd: Weird issues when reading UDT from stored function