create_hello.sql 304 B

123456789101112
  1. CREATE OR REPLACE FUNCTION hello() RETURNS varchar AS $$
  2. << outerblock >>
  3. DECLARE
  4. greetings varchar := 'Hello PL/pgSQL !';
  5. BEGIN
  6. RAISE NOTICE 'From hello() : %', greetings;
  7. greetings := 'Bye !';
  8. RAISE NOTICE 'From hello() : %', greetings;
  9. RETURN greetings;
  10. END;
  11. $$ LANGUAGE plpgsql;