| From: | Kevin Wooten <kdubb(at)me(dot)com> |
|---|---|
| To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | JDBC String to Bool spec |
| Date: | 2017-01-15 23:20:32 |
| Message-ID: | 990BE54A-5803-4B5A-A5C8-BD6DBE75B72C@me.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2017-01-15 23:26:27 | Re: JDBC String to Bool spec |
| Previous Message | Thomas Kellerer | 2017-01-13 19:17:13 | Re: Efficient use of ON CONFLICT DO UPDATE with the PostgreSQL JDBC driver |