Pass constant to function : Function Parameter « Store Procedure Function « PostgreSQL

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

Pass constant to function

postgres=#
postgres=# CREATE FUNCTION "you_me" (integer) RETURNS integer AS '
postgres'#   DECLARE
postgres'#    RENAME $1 TO user_no;
postgres'#     --you INTEGER := 5;
postgres'#   BEGIN
postgres'#     return user_no;
postgres'#   END;' LANGUAGE 'plpgsql';
CREATE FUNCTION
postgres=#
postgres=# select you_me(1);
 you_me
--------
      1
(1 row)

postgres=#

           
       

Related examples in the same category