以下语句可以创建postgreSql 自定义函数if
CREATE OR REPLACE FUNCTION "if" (bl boolean, a integer, b integer, OUT d integer) RETURNS integer
VOLATILE
AS $body$
SELECT CASE
WHEN bl = true
THEN
a
ELSE
b
END;
$body$ LANGUAGE sql
以下语句可以创建postgreSql 自定义函数if
CREATE OR REPLACE FUNCTION "if" (bl boolean, a integer, b integer, OUT d integer) RETURNS integer
VOLATILE
AS $body$
SELECT CASE
WHEN bl = true
THEN
a
ELSE
b
END;
$body$ LANGUAGE sql