Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from marineros inner join reservas on marineros.mid=reservas.mid ;
- select * from marineros inner join reservas on marineros.mid=reservas.mid where reserva>'2000-01-01';
- marinerosMenoresque(edad)
- create or replace function marineroMenorque(edadM int) returns record as $$
- declare
- menores record;
- begin
- select * into menores from marineros where marineros.edad<edadM ;
- return menores;
- end;
- $$ language plpgsql;
- -------------------------------------------********------------------------------------------
- create function trigger() returns trigger as $$
- declare
- variable tipo1;
- variablew tipow;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement