<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>When i use the code below, it is executed data is transferred to the database but the geom is not inserted.<BR><BR>CREATE OR REPLACE FUNCTION calc_point()<BR>
<BR> RETURNS "trigger" AS<BR>
<BR>$BODY$BEGIN<BR>
<BR>NEW.the_geom:=SetSRID(MakePoint(new.point_x, new.point_y), -1) ;<BR>
<BR>RETURN NEW;<BR>
<BR> END$BODY$<BR>
<BR> LANGUAGE 'plpgsql' VOLATILE;<BR>CREATE TRIGGER insert_nodes_geom<BR> BEFORE INSERT OR UPDATE<BR> ON nodes<BR> FOR EACH ROW<BR> EXECUTE PROCEDURE calc_point();<BR><BR>Broun Uganda<BR><BR><BR><br /><hr />Express yourself instantly with MSN Messenger! <a href='http://clk.atdmt.com/AVE/go/onm00200471ave/direct/01/' target='_new'>MSN Messenger</a></body>
</html>