[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