PythonPostgresLab/SQL/plpgsql/create_hello.sql

CREATE OR REPLACE FUNCTION hello() RETURNS varchar AS $$
<< outerblock >>
DECLARE
    greetings varchar := 'Hello PL/pgSQL !';
BEGIN
    RAISE NOTICE 'From hello() : %', greetings;
    greetings := 'Bye !';
    RAISE NOTICE 'From hello() : %', greetings;

    RETURN greetings;
END;
$$ LANGUAGE plpgsql;