Re: [JDBC] JDBC String to Bool spec
| От | Dave Cramer |
|---|---|
| Тема | Re: [JDBC] JDBC String to Bool spec |
| Дата | |
| Msg-id | CADK3HHJQiDaExrbJf1n9vQmkq67XibcdBw6TWMDsBV0rKoV9Bw@mail.gmail.com обсуждение исходный текст |
| Ответ на | [JDBC] JDBC String to Bool spec (Kevin Wooten <kdubb@me.com>) |
| Ответы |
Re: [JDBC] JDBC String to Bool spec
Re: JDBC String to Bool spec |
| Список | pgsql-jdbc |
http://download.oracle.com/otn-pub/jcp/jdbc-4_1-mrel-spec/jdbc4.1-fr-spec.pdf?AuthParam=1484522754_78e98a772cf0c1f6c7f18ab76e324ff5
Has a table on page 211 if that is what you are looking for
On 15 January 2017 at 18:20, Kevin Wooten <kdubb@me.com> wrote:
Does anybody know where in the specification it details the required/acceptable conversions from string values to boolean? I cannot seem to find it in the PDF for 4.2.
I am curious about some of the conversions that are done. For example, calling “ResultSet.getBoolean” on a text/varchar column with the value “1.0”. This conversion succeeds because the driver (both pgjdbc & ng) fallback to decoding the column as a double then converting that by testing it “== 1”; which seems valid but questionable since “!= 0” would also be valid, but vastly different.
This is not allowed by Postgres (e.g. “SELECT “1.0”::bool;” results in an error) and I cannot find anything in JDBC as of yet.
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
В списке pgsql-jdbc по дате отправления: