From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Kevin Wooten <kdubb(at)me(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: JDBC String to Bool spec |
Date: | 2017-01-15 23:26:27 |
Message-ID: | CADK3HHJQiDaExrbJf1n9vQmkq67XibcdBw6TWMDsBV0rKoV9Bw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Has a table on page 211 if that is what you are looking for
Dave Cramer
davec(at)postgresintl(dot)com
www.postgresintl.com
On 15 January 2017 at 18:20, Kevin Wooten <kdubb(at)me(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Wooten | 2017-01-15 23:29:40 | Re: JDBC String to Bool spec |
Previous Message | Kevin Wooten | 2017-01-15 23:20:32 | JDBC String to Bool spec |