Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace view publicidad_por_programa as
- select programa.nombre as programa, fecha, nroveces, publicidad.producto
- from
- publicidad,
- programacionpub as programacion,
- programa
- where
- publicidad.codpub = programacion.codpub and
- programa.codprg = programacion.codprg;
- create type resultados_publicidad_por_programa as (t_programa varchar, t_fecha date, t_veces int);
- create or replace function publicidad_por_programa_para(producto varchar)
- returns resultados_publicidad_por_programa as
- $$
- select programa, fecha, nroveces
- from publicidad_por_programa
- where producto = $1;
- $$ LANGUAGE sql STABLE;
- select * from publicidad_por_programa_para('Coca Cola');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement