123456789101112 |
- 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;
|