Postgres仿oracle的nvl函数
Postgres 仿oracle的nvl函数
------jview@/doc/4dd69e07de80d4d8d15a4f8e.html
调⽤⽅式lect nvl(null,'aaa'),nvl(null,now())
以下代码只提供以上⼏个函数，如果需要更多类型，可按此⽅法增加其他数据类型的nvl函数1，⾃定义函数CREATE OR REPLACE FUNCTION nvl(character varying, character varying) RETURNS character varying AS $BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(boolean, boolean)
RETURNS boolean AS
$BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(interval, interval)
RETURNS interval AS
$BODY$
declare
begin
在家怎样自制鞭子if $1 is not null then
return $1;
el
return $2;
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(time without time zone, time without time zone) RETURNS time without time zone AS
$BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(date, date)
出国留学购车
RETURNS date AS
$BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
舅妈的秘密$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(numeric, numeric)
RETURNS numeric AS
$BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(timestamp without time zone, timestamp without time zone) RETURNS timestamp without time zone AS
$BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
洋芋怎么做好吃
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(timestamp with time zone, timestamp with time zone) RETURNS timestamp with
time zone AS
$BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
插入COST 100;
CREATE OR REPLACE FUNCTION nvl(text, text)
RETURNS text AS
$BODY$
declare
begin
if $1 is not null then
return $1;
el
return $2;
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
2，或者调⽤coalesce;
CREATE OR REPLACE FUNCTION nvl(character varying, character varying) RETURNS character varying AS
$BODY$
惹祸begin
return coalesce($1, $2);
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE绿豆沙的功效
COST 100;
CREATE OR REPLACE FUNCTION nvl(boolean, boolean)
RETURNS boolean AS
$BODY$
declare
begin
return coalesce($1, $2);
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(interval, interval)
RETURNS interval AS
$BODY$
declare
begin
return coalesce($1, $2);
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(time without time zone, time without time zone) RETURNS time without time zone AS
$BODY$
广告违禁词declare
return coalesce($1, $2);
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
CREATE OR REPLACE FUNCTION nvl(date, date)
RETURNS date AS
$BODY$
declare
begin
