I've actually never written a trigger, so the manual will be able to tell you 
how to do it better than me... I just know the concept and thought it would 
apply.

Chris

Quoting Tyler Mitchell <TMitchell@lignum.com>:

> > 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.





