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