[postgis-users] Postgis views

[Tyler Mitchell]

> It would be possible to put a trigger on your table that took the 
> float columns 
> and created a point or line geometry out of them, and updated a 
> geometry column 
> in your database, every time a row was inserted or updated. Then 
youcould do 
> all the geometric operations you want, even spatial indexing, without 
really 
> having to worry about the non-standard sql portion of the database 
> (other than 
> writing the initial trigger function).

Nice suggestion Chris! An often overlooked feature of the database.  Got 
any examples handy?  I'm using views like this when I really should use a 
trigger.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040227/d6268878/attachment.html>