All pastes #2064190 Raw Edit

Unnamed

public text v1 · immutable
#2064190 ·published 2011-05-19 07:45 UTC
rendered paste body
CREATE OR REPLACE FUNCTION W_Line_SubString(geom geometry, s float, e float)
  RETURNS geometry AS
$BODY$
BEGIN
	-- this is a wrapper around ST_Line_Substring

	IF s < 0.0 THEN 
		RAISE WARNING 'W_Line_SubString: s < 0 -> [%]', s;
		s := 0;
	END IF;

	IF e > 1.0 THEN 
		RAISE WARNING 'W_Line_SubString: e > 1 -> [%]', e;
		e := 1;
	END IF;

	RETURN ST_Line_SubString(geom, s, e);
END;
$BODY$
  LANGUAGE plpgsql STABLE
  COST 1;