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 you
CREATE OR REPLACE FUNCTION insert_new_links() RETURNS "trigger"
AS 'DECLAREstartpoint geometry;
endpoint geometry;
BEGIN
startpoint = 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
_________________________________________________________________
Play free games, earn tickets, get cool prizes! Join Live Search Club.
http://club.live.com/home.aspx?icid=CLUB_wlmailtextlink
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
