[postgis-users] Triger

[Ravi Kumar]

Hi,
1 am using Gammu (http://www.ubuntugeek.com/wammu-mobile-phone-manager.html) to receive SMS of location from OSMand ( http://osmand.net/ ).
2 Have written an sql to fishout the Long and Lat from the SMS and convert to easting and northing.

TRIGGER

Now need to write a trigger such that the operation is automated soon after an SMS is received from OSMand 

Pl help me write the trigger



This inturn will update a webpage for live information.

Thanx in advance

Ravi Kumar