Functions with Output Parameters : Create Function « Store Procedure Function « PostgreSQL

1. PostgreSQL
2. Store Procedure Function
3. Create Function

Functions with Output Parameters

postgres=#
postgres=# -- Functions with Output Parameters
postgres=#
postgres=# CREATE FUNCTION add_em (IN x int, IN y int, OUT sum int)
postgres-# AS 'SELECT $1 + $2'
postgres-# LANGUAGE SQL;
CREATE FUNCTION
postgres=#
postgres=# SELECT add_em(3,7);
 REATE
 add_em
--------
     10
(1 row)

postgres=#
postgres=# drop function add_em(IN x int, IN y int, OUT sum int);
DROP FUNCTION
postgres=#
postgres=#
           
       

Related examples in the same category