Advertisement
Rahmadnet

PL/pgSQL block structure

Jul 25th, 2019
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DO $$
  2. DECLARE
  3.   v_message VARCHAR( 255 ) := 'Hello World!';
  4. BEGIN
  5.   raise notice 'hi %',v_message ;
  6. end $$;
  7.  
  8. do $$
  9. declare
  10.     a integer := 10;
  11.     b integer := 100;
  12.     c integer;
  13.     begin
  14.         if a > b then
  15.          c:= a;
  16.         else
  17.             c:= b;
  18.         end if;
  19.     raise notice ' Maximum number in 10 and 100 : %', c;
  20.     end $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement