OUT parameter : Function Parameter « Store Procedure Function « PostgreSQL






OUT parameter


postgres=#
postgres=#
postgres=# CREATE FUNCTION sales_tax(subtotal real, OUT tax real) AS $$
postgres$# BEGIN
postgres$#    tax := subtotal * 0.06;
postgres$# END;
postgres$# $$ LANGUAGE plpgsql;

postgres=#
postgres=# select sales_tax(100);
   REATE
 sales_tax
-----------
         6
(1 row)

postgres=#
postgres=# drop function sales_tax(subtotal real, OUT tax real);
DROP FUNCTION
postgres=#
postgres=#
           
       








Related examples in the same category

1.Here the $1 references the value of the first function argument whenever the function is invoked
2.Pass constant to function
3.Output parameters are most useful when returning multiple values
4.Real number parameter
5.Two out parameters
6.'Anyelement' parameter
7.Pass in a whole row
8.Use defined data type as the function parameter