功能简介
为了兼容ORACLE数据库语法,LightDB从23.2版本开始支持NUMBER类型和BOOL类型的比较。
但是仅是支持相等(“=”)和不相等(“<>”)两个运算符,且仅限于ORACLE兼容模式下。
NUMBER是作为NUMERIC的别名实现的,下面以NUMERIC描述:
- 支持 numeric = Boolean 和 Boolean = numeric, number <> Boolean, Boolean
<> numeric4种重载; - numeric为0时和false相等;
- numeric为1时和true相等;
- numeric既不等于0也不等于1的时候,和true,false都不相等;
用法
select 0::numeric = true;
?column?
----------
f
(1 row)
select 1::numeric = true;
?column?
----------
t
(1 row)
select 0::numeric = false;
?column?
----------
t
(1 row)
select 1::numeric = false;
?column?
----------
f
(1 row)
select 1.1::numeric(10,0) = true;
?column?
----------
t
(1 row)
select 0.1::numeric(10,0) = true;
?column?
----------
f
(1 row)
select 1.1::numeric(10,0) = false;
?column?
----------
f
(1 row)
select 0.1::numeric(10,0) = false;
?column?
----------
t
(1 row)
select 2::numeric = false;
?column?
----------
f
(1 row)
select 2::numeric = true;
?column?
----------
f
(1 row)
select true = 0::numeric;
?column?
----------
f
(1 row)
select true = 1::numeric;
?column?
----------
t
(1 row)
select false = 0::numeric;
?column?
----------
t
(1 row)
select false = 1::numeric;
?column?
----------
f
(1 row)
select true = 1.1::numeric(10,0);
?column?
----------
t
(1 row)
select true = 0.1::numeric(10,0);
?column?
----------
f
(1 row)
select false = 1.1::numeric(10,0);
?column?
----------
f
(1 row)
select false = 0.1::numeric(10,0);
?column?
----------
t
(1 row)
select false = 2::numeric;
?column?
----------
f
(1 row)
select true = 2::numeric;
?column?
----------
f
(1 row)
select 0::numeric <> true;
?column?
----------
t
(1 row)
select 1::numeric <> true;
?column?
----------
f
(1 row)
select 0::numeric <> false;
?column?
----------
f
(1 row)
select 1::numeric <> false;
?column?
----------
t
(1 row)
select 1.1::numeric(10,0) <> true;
?column?
----------
f
(1 row)
select 0.1::numeric(10,0) <> true;
?column?
----------
t
(1 row)
select 1.1::numeric(10,0) <> false;
?column?
----------
t
(1 row)
select 0.1::numeric(10,0) <> false;
?column?
----------
f
(1 row)
select 2::numeric <> false;
?column?
----------
f
(1 row)
select 2::numeric <> true;
?column?
----------
f
(1 row)
select true <> 0::numeric;
?column?
----------
t
(1 row)
select true <> 1::numeric;
?column?
----------
f
(1 row)
select false <> 0::numeric;
?column?
----------
f
(1 row)
select false <> 1::numeric;
?column?
----------
t
(1 row)
select true <> 1.1::numeric(10,0);
?column?
----------
f
(1 row)
select true <> 0.1::numeric(10,0);
?column?
----------
t
(1 row)
select false <> 1.1::numeric(10,0);
?column?
----------
t
(1 row)
select false <> 0.1::numeric(10,0);
?column?
----------
f
(1 row)
select false <> 2::numeric;
?column?
----------
f
(1 row)
select true <> 2::numeric;
?column?
----------
f
(1 row)