Re: [JDBC] JDBC String to Bool spec

On 2017-01-16 00:20, Kevin Wooten 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.

As far as I know the JDBC spec defers to the SQL standard specification
for this. Unfortunately I don't have a copy handy to check how the SQL
standard defines it.

Mark