Re: JDBC String to Bool spec

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC String to Bool spec
Date: 2017-01-16 08:59:24
Message-ID: o5i217$tou$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Mark Rotteveel schrieb am 16.01.2017 um 09:37:
> 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.

<boolean value expression> ::=
<boolean term>
| <boolean value expression> OR <boolean term>

<boolean term> ::=
<boolean factor>
| <boolean term> AND <boolean factor>

<boolean factor> ::=
[ NOT ] <boolean test>

<boolean test> ::=
<boolean primary> [ IS [ NOT ] <truth value> ]

<truth value> ::=
TRUE
| FALSE
| UNKNOWN

<boolean primary> ::=
<predicate>
| <boolean predicand>

<boolean predicand> ::=
<parenthesized boolean value expression>
| <nonparenthesized value expression primary>

<parenthesized boolean value expression> ::=
<left paren> <boolean value expression> <right paren>

so it boils down to

<truth value> ::=
TRUE
| FALSE
| UNKNOWN

as far as I can tell.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mark Rotteveel 2017-01-16 10:10:30 Re: JDBC String to Bool spec
Previous Message Mark Rotteveel 2017-01-16 08:37:46 Re: JDBC String to Bool spec