Advertisement
LaCaraDeLaVerga

17 de mayo JZJ <3

May 17th, 2018
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select * from marineros inner join reservas on marineros.mid=reservas.mid ;
  2.  
  3. select * from marineros inner join reservas on marineros.mid=reservas.mid where reserva>'2000-01-01';
  4.  
  5. marinerosMenoresque(edad)
  6.  
  7.  
  8.  
  9. create or replace function marineroMenorque(edadM int) returns  record as $$
  10.  
  11. declare
  12.     menores record;
  13.  
  14. begin
  15.     select * into menores from marineros where marineros.edad<edadM ;
  16.     return menores;
  17. end;
  18.  
  19. $$ language plpgsql;
  20.  
  21. -------------------------------------------********------------------------------------------
  22. create function trigger() returns trigger as $$
  23. declare
  24.    variable tipo1;
  25.   variablew tipow;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement