[postgis-users] Multipoint with Characteristics

[Kevin Ridge]

Hello,
I am new to postgis and was wondering how to solve the following issue.

Lets say i have a million points each of which has a color defined. Is there
a way to represent this using multipoint? I am currently using a point but
each point has its own record which makes inserting and calculating
intersections very time consuming.

Is there any efficient way of doing this instead of making a million rows?

Thanks,
Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090727/5b0b3270/attachment.html>