Dear all,A trying to write a trigger that would automatically create lines
joining points in the sequence in which i insert them. If I insert point AA
then BB then CC, i want lines drawn as AA-BB & BB-CC, Using the trigger below
lines are drawn ( atleast i can see the gid in table links) without the
geometry.May anyone advise me on this.Thank youCREATE OR REPLACE FUNCTION
insert_new_links() RETURNS "trigger" AS 'DECLAREstartpoint geometry; endpoint
geometry;BEGINstartpoint = asEWKT(NEW.the_geom) WHERE NEW.gid =
NEW.gid;endpoint = asEWKT(NEW.the_geom) WHERE NEW.gid = NEW.gid+1;INSERT INTO
links(the_geom)VALUES(MakeLine(startpoint, endpoint ));RETURN NEW; END'
LANGUAGE plpgsql; CREATE OR TRIGGER insert_new_links_insert BEFORE
INSERT ON nodes FOR EACH ROW EXECUTE PROCEDURE insert_new_links();Broun
Uganda
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
