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

[Tom van Tilburg]

To answer my own questions: it should have been UNION *ALL*
Since UNION will also check for duplicates which is not needed in my case
(sticking not next to monitor)

On Sat, 10 Oct 2015 at 12:28 Tom van Tilburg <tom.van.tilburg at gmail.com>
wrote:

> 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/f8dcbc88/attachment.html>