Returning a concatenated string : Function Return « Store Procedure Function « PostgreSQL





Returning a concatenated string

postgres=#
postgres=#
postgres=# -- Returning a concatenated string
postgres=#
postgres=# CREATE FUNCTION compound_word(text, text) RETURNS text AS '
postgres'#   DECLARE
postgres'#
postgres'#      -- Define aliases for function arguments.
postgres'#     word1 ALIAS FOR $1;
postgres'#     word2 ALIAS FOR $2;
postgres'#
postgres'#   BEGIN
postgres'#
postgres'#      -- Return the resulting joined words.
postgres'#     RETURN word1 || word2;
postgres'#
postgres'#   END;
postgres'#
postgres'# ' LANGUAGE 'plpgsql';
ERROR:  function "compound_word" already exists with same argument types
postgres=#
postgres=# SELECT compound_word('break', 'fast');
 compound_word
---------------
 breakfast
(1 row)

postgres=#

           
       










Related examples in the same category

1.Define function to add two parameters together
2.Return entire row
3.Using the result set returned from the function
4.Return 'double' from function
5.A SQL function that returns a book title based on the ID number passed to the function
6.Return a table from a function