有人知道为什么Oracle的NVL (和NVL2)函数总是计算第二个参数,即使第一个参数不是NULLCREATE FUNCTION nvl_test RETURN NUMBER AS RETURN 1;SELECT NVL( 0, nvl_test ) FROM dual
返回0,已调用nvl_test,即使由于
我试图在postgres中使用NVL函数。create or replace function nvl (anyelement, anyelement) selectCONTEXT: SQL function "nvl" during inlining
testdb=> SELECT nvl( sum(balance), 0 ) as b FROM db.bankWHERE user = 123