Real number parameter : Function Parameter « Store Procedure Function « PostgreSQL






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

Real number parameter

postgres=#
postgres=#
postgres=#
postgres=# CREATE FUNCTION sales_tax(subtotal real) RETURNS real AS $$
postgres$# BEGIN
postgres$#    RETURN subtotal * 0.06;
postgres$# END;
postgres$# $$ LANGUAGE plpgsql;

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

postgres=#
postgres=# drop function sales_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.OUT parameter
4.Output parameters are most useful when returning multiple values
5.Two out parameters
6.'Anyelement' parameter
7.Pass in a whole row
8.Use defined data type as the function parameter