CREATE FUNCTION a_concellos(int) RETURNS setof concellos AS '
SELECT id_con, municipio, id_provincia
FROM concellos
where id_provincia = $1
;
' LANGUAGE SQL;
select * from a_concellos(3);
SELECT id_con, municipio, id_provincia
FROM concellos
where id_provincia = $1
;
' LANGUAGE SQL;
select * from a_concellos(3);
No hay comentarios:
Publicar un comentario