数据仓库服务 GAUSSDB(DWS)-算子:NOTNULL and ISNULL

时间:2024-10-26 11:41:20

NOTNULL and ISNULL

Netezza语法

迁移后语法

1
CASE WHEN ((A1.EXCEPT_OFF_SEQU_NO NOTNULL) AND (A2. LOG _SEQU_NO ISNULL)) THEN 0 ELSE 1 END AS FLG
1
CASE WHEN ((A1.EXCEPT_OFF_SEQU_NO NOTNULL) AND (A2.LOG_SEQU_NO ISNULL)) THEN 0 ELSE 1 END AS FLG
support.huaweicloud.com/tg-dws/dws_07_6825.html