[pgpointcloud] Trying to UNION pointclouds but no equality operator for pcpatch

Tom van Tilburg tom.van.tilburg at gmail.com
Sat Oct 10 03:28:04 PDT 2015


I have spread my large set of pointcloud files over several tables, split
into logical tiles. Now I would like to have 1 view where all these tables
are unioned together, so I don't have to bother to find out which table I
have to use for every new query.
For this I do:

CREATE OR REPLACE VIEW vw_pointcloud AS
   SELECT id, pa
   FROM pointcloud_1
   UNION
   SELECT id, pa
   FROM pointcloud_2;

Postgres is hitting back though with:
  ERROR:  could not identify an equality operator for type pcpatch
  LINE 1: SELECT id, pa

I remember I have seen this issue before on a mailinglist, but can't find
it anymore. Is it solvable with casting back and forth to other types for
instance?

Tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20151010/59f5bcd4/attachment.html>


More information about the pgpointcloud mailing list