Re: Array type error
От | RW Shore |
---|---|
Тема | Re: Array type error |
Дата | |
Msg-id | AANLkTikr8cO6hujSSycMN1Mi7a9j3hDjTYQMtor+vfjH@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Array type error (Oliver Jowett <oliver@opencloud.com>) |
Ответы |
Re: Array type error
|
Список | pgsql-jdbc |
Thanks for the response. My issue is that the input and output formats aren't interchangable. The application in question is part of a replication system that converts changes into XML, processes the changes, and ultimately applies them to a target database. If the array instance says that it contains BIT data, I try to extract the array contents as a binary array; this won't work if the actual array contents are BOOLEAN. Also, as far as I can tell, the only way to insert an array value is to stringify it; the string representation for a bit array is quite different from that of a boolean array.
I understand the interchangability of bit(1) and boolean at a certain level, but IMO this is still an inconsistency at best if not an outright bug.
I understand the interchangability of bit(1) and boolean at a certain level, but IMO this is still an inconsistency at best if not an outright bug.
On Mon, Feb 14, 2011 at 6:29 AM, Oliver Jowett <oliver@opencloud.com> wrote:
RW Shore wrote:These types are effectively interchangeable in JDBC.However, the getBaseType( ) method on this object returns java.sql.Types.BIT ( -7 ) rather than the correct value java.sql.Types.BOOLEAN (16).
See the list archives for past discussion.
Oliver
В списке pgsql-jdbc по дате отправления: