Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION public.sp_sel_categoria(IN _codigo integer)
- RETURNS TABLE(acat_cod smallint, acat_nombre character varying, acat_descrip character varying) AS
- $BODY$
- BEGIN
- IF _codigo =-1 THEN
- return query
- SELECT cat_cod, cat_nombre, cat_descrip
- FROM categoria
- order by cat_nombre;
- ELSE
- return query
- SELECT cat_cod, cat_nombre, cat_descrip
- FROM categoria
- WHERE cat_cod = _codigo
- order by cat_nombre;
- END IF;
- END;
- $BODY$
- LANGUAGE plpgsql VOLATILE
- COST 100
- ROWS 900001;
- ALTER FUNCTION public.sp_sel_categoria(integer)
- OWNER TO postgres;
- while (resultado.next())
- {
- EntCategoria categoria = new EntCategoria();
- categoria.setCodigo(resultado.getInt("acat_cod "));
- categoria.setNombre(resultado.getString("acat_nombre "));
- listCategorias.add(categoria);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement