PostgreSQL自定义函数返回单条记录类型的例子...

概述CREATE OR REPLACE function fun_getRecSeq_range(p_dt timestamp) returns record as $BODY$declare c_str varchar;declare ret record;begin c_str:='0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$.`'; s

CREATE OR REPLACE  function fun_getRecSeq_range(p_dt timestamp) returns record as $BODY$declare c_str varchar;declare ret record;begin   c_str:='0123456789ABCDEFGHIJKLMnopQRSTUVWXYZ!@#$.`';   select (substr(c_str,extract(YEAR from p_dt)::int-2010+1,1)||   substr(c_str,extract(month from p_dt)::int+1,extract(day from p_dt)::int+1,1) )::varchar as seqStart,(substr(c_str,1)||'ZZZZ')::varchar as seqEnd   into ret ;         return ret ;end;$BODY$LANGUAGE plpgsql VolATILE  COST 100;  select * from fun_getRecSeq_range(current_date) as (seqStart varchar,seqEnd varchar)

上面例子将日期转为recseq的范围,单条记录的,若要用多条记录,要用set of record ...

总结

以上是内存溢出为你收集整理的PostgreSQL自定义函数返回单条记录类型的例子...全部内容，希望文章能够帮你解决PostgreSQL自定义函数返回单条记录类型的例子...所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。