-- FUNCTION: public.dynamic_placelist_select(integer, timestamp without time zone)

-- DROP FUNCTION public.dynamic_placelist_select(integer, timestamp without time zone);

CREATE OR REPLACE FUNCTION public.dynamic_placelist_select(
    eigyousyo_idl integer,
    minversionl timestamp without time zone)
RETURNS TABLE(address1 character varying, eigyousyo_id integer, icon integer, latitude character varying, longitude character varying, place_code character varying, place_id integer, place_name character varying, deletef smallint, version timestamp without time zone)
    LANGUAGE 'plpgsql'
    COST
    VOLATILE
    ROWS
AS $BODY$
BEGIN
-- Insert statements for procedure here
    RETURN QUERY

select mst_Place.address1,
mst_Place.eigyousyo_id,
mst_Place.icon,
mst_Place.latitude,
mst_Place.longitude,
mst_Place.place_code,
mst_Place.place_id,
mst_Place.place_name,
mst_Place.deletef,
mst_Place.version
from mst_Place
where (mst_Place.eigyousyo_id=eigyousyo_idl and
mst_Place.version)
order by mst_Place.place_code;
END;

$BODY$;

ALTER FUNCTION public.dynamic_placelist_select(integer, timestamp without time zone)
    OWNER TO postgres;