Hi,
You could create triangles by calling st_makeLine and st_makePolygon:
select st_makePolygon(st_makeLine('{point1, point2, point3, point1}'))
from triangles
(the 4 points are put in a array before calling makeLine).
Yes for the Gist index on the column.
Nicolas
On 8 October 2012 16:03, Ed Linde <edoli...@gmail.com> wrote:
> Hi All,
> I am looking at an easy way to load a lot of triangles into a geometry
> column. Wondering what is the best way to
> create a triangle when I have 3 points? Is there a function I can use?
> Also can I just index this column with Gist and then query against a box I
> make to see what triangles intersect
> with this rectangle?
>
> Cheers,
> Ed
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
