腾讯云数据仓库 TCHouse-P

{"list":[{"id":97787,"title":"动态与公告","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_97787_cn.pdf","children":[{"id":97688,"title":"产品公告","type":"page","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_97688_cn.pdf","link":"/document/product/878/97688"}],"link":"/document/product/878/97787"},{"id":18777,"title":"产品简介","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_18777_cn.pdf","children":[{"id":18778,"title":"产品概述","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/18778"},{"id":18779,"title":"应用场景","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/18779"},{"id":36781,"title":"集群架构","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/36781"},{"id":20065,"title":"节点规格","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/20065"}],"link":"/document/product/878/18777"},{"id":20066,"title":"购买指南","type":"directory","docType":"price","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_20066_cn.pdf","children":[{"id":20077,"title":"计费概述","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/20077"},{"id":31447,"title":"购买方式","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/31447"},{"id":31448,"title":"欠费说明","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/31448"},{"id":31449,"title":"退费说明","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/31449"}],"link":"/document/product/878/20066"},{"id":20064,"title":"快速入门","type":"page","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_20064_cn.pdf","link":"/document/product/878/20064"},{"id":20067,"title":"操作指南","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_20067_cn.pdf","children":[{"id":31440,"title":"管理集群","type":"directory","docType":"default","pdfUrl":"","children":[{"id":31441,"title":"创建集群","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/31441"},{"id":33309,"title":"集群信息","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33309"},{"id":31442,"title":"扩容集群","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/31442"},{"id":31444,"title":"管理 IP 白黑名单","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/31444"},{"id":33310,"title":"管理资源队列","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33310"},{"id":33316,"title":"销毁集群","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33316"}],"link":"/document/product/878/31440"},{"id":44855,"title":"访问数据仓库","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_44855_cn.pdf","children":[{"id":20075,"title":"连接数据库","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/20075"},{"id":20072,"title":"管理用户权限","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/20072"},{"id":20070,"title":"定义数据库","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/20070"},{"id":20071,"title":"管理数据","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/20071"}],"link":"/document/product/878/44855"},{"id":47385,"title":"监控告警","type":"directory","docType":"default","pdfUrl":"","children":[{"id":47386,"title":"告警配置","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/47386"}],"link":"/document/product/878/47385"},{"id":47402,"title":"访问管理","type":"directory","docType":"default","pdfUrl":"","children":[{"id":47403,"title":"访问管理概述","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/47403"},{"id":47410,"title":"策略设置","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/47410"},{"id":47406,"title":"策略授予","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/47406"}],"link":"/document/product/878/47402"}],"link":"/document/product/878/20067"},{"id":33570,"title":"开发指南","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_33570_cn.pdf","children":[{"id":102028,"title":"库/模式/表/索引/视图/物化视图等 DDL 操作","type":"directory","docType":"default","pdfUrl":"","children":[{"id":102029,"title":"数据库管理","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/102029"}],"link":"/document/product/878/102028"},{"id":33572,"title":"常量与宏","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33572"},{"id":33574,"title":"函数和操作符","type":"directory","docType":"default","pdfUrl":"","children":[{"id":33575,"title":"逻辑操作符","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33575"},{"id":33576,"title":"比较操作符","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33576"},{"id":33578,"title":"字符串函数和操作符","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33578"},{"id":33579,"title":"模式匹配","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33579"},{"id":33581,"title":"日期时间函数和操作符","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33581"},{"id":33582,"title":"几何函数和操作符","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33582"},{"id":33584,"title":"序列操作函数","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33584"},{"id":33585,"title":"条件表达式","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33585"},{"id":33587,"title":"聚合函数","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33587"},{"id":33588,"title":"子查询表达式","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33588"},{"id":33589,"title":"行值与数组的比较","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33589"},{"id":33590,"title":"序列函数","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33590"},{"id":33591,"title":"系统信息函数","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33591"},{"id":33592,"title":"系统管理函数","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33592"}],"link":"/document/product/878/33574"},{"id":33594,"title":"DDL 语法一览表","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33594"},{"id":33692,"title":"DML 语法一览表","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33692"},{"id":33595,"title":"DCL 语法一览表","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33595"},{"id":33596,"title":"SQL 语法命令参考","type":"directory","docType":"default","pdfUrl":"","children":[{"id":33597,"title":"SQL 语法概要","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33597"},{"id":33598,"title":"ABORT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33598"},{"id":33602,"title":"ALTER FILESPACE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33602"},{"id":33608,"title":"ALTER SCHEMA","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33608"},{"id":33610,"title":"ALTER TABLE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33610"},{"id":33611,"title":"ALTER TABLESPACE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33611"},{"id":33612,"title":"ALTER USER","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33612"},{"id":33613,"title":"ALTER VIEW","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33613"},{"id":33614,"title":"ANALYZE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33614"},{"id":33615,"title":"BEGIN","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33615"},{"id":33616,"title":"CHECKPOINT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33616"},{"id":33617,"title":"COMMENT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33617"},{"id":33618,"title":"COMMIT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33618"},{"id":33621,"title":"CREATE EXTENSION","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33621"},{"id":33622,"title":"CREATE EXTERNAL TABLE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33622"},{"id":33624,"title":"CREATE INDEX","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33624"},{"id":33625,"title":"CREATE RESOURCE QUEUE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33625"},{"id":33627,"title":"CREATE SCHEMA","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33627"},{"id":33628,"title":"CREATE SEQUENCE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33628"},{"id":33629,"title":"CREATE TABLE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33629"},{"id":33630,"title":"CREATE TABLE AS","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33630"},{"id":33631,"title":"CREATE TABLESPACE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33631"},{"id":33632,"title":"CREATE USER","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33632"},{"id":33633,"title":"CREATE VIEW","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33633"},{"id":33634,"title":"DECLARE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33634"},{"id":33636,"title":"DISCARD","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33636"},{"id":33638,"title":"DROP DATABASE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33638"},{"id":33639,"title":"DROP EXTENSION","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33639"},{"id":33640,"title":"DROP EXTERNAL TABLE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33640"},{"id":33641,"title":"DROP FILESPACE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33641"},{"id":33642,"title":"DROP FUNCTION","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33642"},{"id":33643,"title":"DROP INDEX","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33643"},{"id":33644,"title":"DROP LANGUAGE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33644"},{"id":33645,"title":"DROP RESOURCE QUEUE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33645"},{"id":33646,"title":"DROP ROLE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33646"},{"id":33654,"title":"END","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33654"},{"id":33655,"title":"EXPLAIN","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33655"},{"id":33656,"title":"FETCH","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33656"},{"id":33657,"title":"GRANT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33657"},{"id":33659,"title":"LOAD","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33659"},{"id":33661,"title":"MOVE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33661"},{"id":33662,"title":"PREPARE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33662"},{"id":33665,"title":"REINDEX","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33665"},{"id":33669,"title":"ROLLBACK","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33669"},{"id":33670,"title":"ROLLBACK TO SAVEPOINT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33670"},{"id":33672,"title":"SAVEPOINT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33672"},{"id":33673,"title":"SELECT","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33673"},{"id":33675,"title":"SELECT INTO","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33675"},{"id":33676,"title":"SET","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33676"},{"id":33677,"title":"SET ROLE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33677"},{"id":33679,"title":"SET TRANSACTION","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33679"},{"id":33680,"title":"SHOW","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33680"},{"id":33682,"title":"TRUNCATE","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33682"},{"id":33684,"title":"VACUUM","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/33684"}],"link":"/document/product/878/33596"}],"link":"/document/product/878/33570"},{"id":46337,"title":"性能指标","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_46337_cn.pdf","children":[{"id":46338,"title":"TPC-B","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/46338"}],"link":"/document/product/878/46337"},{"id":20063,"title":"工具及下载","type":"page","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_20063_cn.pdf","link":"/document/product/878/20063"},{"id":44485,"title":"数据接入","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_44485_cn.pdf","children":[{"id":34875,"title":"使用外表高速导入或导出 COS 数据","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/34875"},{"id":44546,"title":"使用外表同步 EMR 数据","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/44546"},{"id":47237,"title":"使用 rule 规则实现云数据仓库 PostgreSQL upsert 操作","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/47237"}],"link":"/document/product/878/44485"},{"id":46569,"title":"BI 分析工具","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_46569_cn.pdf","children":[{"id":89529,"title":"腾讯云 BI","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/89529"}],"link":"/document/product/878/46569"},{"id":47354,"title":"数仓开发","type":"directory","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_47354_cn.pdf","children":[{"id":47355,"title":"云上搭建 Airflow","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/47355"}],"link":"/document/product/878/47354"},{"id":98865,"title":"API 文档","type":"directory","docType":"api","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_98865_cn.pdf","children":[{"id":98906,"title":"更新历史","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98906"},{"id":98896,"title":"简介","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98896"},{"id":98905,"title":"API 概览","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98905"},{"id":98897,"title":"调用方式","type":"directory","docType":"default","pdfUrl":"","children":[{"id":98898,"title":"请求结构","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98898"},{"id":98899,"title":"公共参数","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98899"},{"id":98900,"title":"签名方法 v3","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98900"},{"id":98901,"title":"签名方法","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98901"},{"id":98902,"title":"返回结果","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98902"},{"id":98903,"title":"参数类型","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98903"}],"link":"/document/product/878/98897"},{"id":100125,"title":"信息查询相关接口","type":"directory","docType":"default","pdfUrl":"","children":[{"id":100195,"title":"描述云原生实例信息","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/100195"},{"id":100444,"title":"获取云原生实例列表","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/100444"},{"id":100160,"title":"获取集群实例状态","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/100160"},{"id":100126,"title":"获取集群精简信息列表","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/100126"},{"id":100615,"title":"获取集群信息","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/100615"}],"link":"/document/product/878/100125"},{"id":98892,"title":"实例相关接口","type":"directory","docType":"default","pdfUrl":"","children":[{"id":98894,"title":"创建集群","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98894"},{"id":98893,"title":"销毁集群","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98893"},{"id":100159,"title":"修改实例信息","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/100159"}],"link":"/document/product/878/98892"},{"id":98895,"title":"数据结构","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98895"},{"id":98904,"title":"错误码","type":"page","docType":"default","pdfUrl":"","link":"/document/product/878/98904"}],"link":"/document/product/878/98865"},{"id":18782,"title":"常见问题","type":"page","docType":"faq","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_18782_cn.pdf","link":"/document/product/878/18782"},{"id":92783,"title":"服务等级协议","type":"page","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_92783_cn.pdf","link":"/document/product/878/92783"},{"id":45996,"title":"联系我们","type":"page","docType":"default","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_45996_cn.pdf","link":"/document/product/878/45996"},{"id":18783,"title":"词汇表","type":"page","docType":"glossary","pdfUrl":"https://main.qcloudimg.com/raw/document/product/pdf/878_18783_cn.pdf","link":"/document/product/878/18783"}],"categoryId":878,"title":"腾讯云数据仓库 TCHouse-P","lang":"zh"}

文档中心腾讯云数据仓库 TCHouse-P 开发指南函数和操作符逻辑操作符

逻辑操作符

最近更新时间：2021-03-02 17:49:09

我的收藏

常用的逻辑操作符有 AND、OR、NOT，有三个结果值 TRUE、FALSE、NULL。其中 NULL 代表未知值。
a
b
a AND b
a OR b
NOT a
TRUE
TRUE
TRUE
TRUE
FALSE
TRUE
FALSE
FALSE
TRUE
FALSE
TRUE
NULL
NULL
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
NULL
FALSE
NULL
TRUE
NULL
NULL
NULL
NULL
NULL

上一篇: 常量与宏下一篇: 比较操作符