On 3/2/18, Olivier Mascia wrote:
> is TRUE an alias to 1?
Yes.
Just to be clear, if it is possible to resolve TRUE to the name of a
column in a table, then it will refer to that column. TRUE only
becomes an alias for 1 if there is no other way to resolve the name.
This is necessary for backward
> Le 2 mars 2018 à 13:19, Richard Hipp a écrit :
>
>> Will insert into T values(FALSE) actually store integer 0 no matter column
>> affinity or will it follow affinity?
>
> No. FALSE is merely an alias for 0. Affinity still applies. If the
> column is of type TEXT, then it will store '0', not
On 3/2/18, J Decker wrote:
> On Fri, Mar 2, 2018 at 4:19 AM, Richard Hipp wrote:
>
>> On 3/2/18, Olivier Mascia wrote:
>> >
>> > What values will be considered FALSE, and hence will TRUE be NOT FALSE
>> > or
>> > equality to some other specific value?
>>
>> I have a note to provide additional do
On Fri, Mar 2, 2018 at 4:19 AM, Richard Hipp wrote:
> On 3/2/18, Olivier Mascia wrote:
> >
> > What values will be considered FALSE, and hence will TRUE be NOT FALSE or
> > equality to some other specific value?
>
> I have a note to provide additional documentation on this before the
> release.
On 3/2/18, Olivier Mascia wrote:
>
> What values will be considered FALSE, and hence will TRUE be NOT FALSE or
> equality to some other specific value?
I have a note to provide additional documentation on this before the release.
In short, a value is FALSE is, when converted into a floating poin
Olivier Mascia wrote:
> What values will be considered FALSE
0, and they keyword "FALSE".
FALSE is an alias for the integer 0.
> and hence will TRUE be NOT FALSE or equality to some other specific value?
What exactly do you mean with "be" and "equality"?
The SQL = and IS operators work as speci
Dear,
3.23.0 (pending) cites:
> • Recognize TRUE and FALSE as constants. (For compatibility, if there
> are columns named "true" or "false", then the identifiers refer to the
> columns rather than Boolean constants.)
> • Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT F
7 matches
Mail list logo