PL/pgSQL的anyelement例子

pgsql=# CREATE OR REPLACE FUNCTION diff_inc(IN anyelement, IN anyelement
pgsql(#   , OUT diff integer, OUT f_val anyelement, OUT l_val anyelement)
pgsql-# RETURNS record
pgsql-# AS
pgsql-# $$
pgsql$# BEGIN
pgsql$#    diff = ($1 - $2)::integer;
pgsql$#    f_val = $1 +1;
pgsql$#    l_val = $2 +1; 
pgsql$# END;
pgsql$# $$
pgsql-# language plpgsql;
CREATE FUNCTION
pgsql=# 

pgsql=# select (diff_inc(12,14)).*;
 diff | f_val | l_val 
------+-------+-------
   -2 |    13 |    15
(1 row)


pgsql=# SELECT (diff_inc('2011-12-31'::date, '2012-01-05'::date)).*;
 diff |   f_val    |   l_val    
------+------------+------------
   -5 | 2012-01-01 | 2012-01-06
(1 row)

pgsql=#