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

[Sandro Santilli]

On Sat, Oct 10, 2015 at 10:28:04AM +0000, Tom van Tilburg wrote:

> 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?

You can use "UNION ALL" instead of UNION to not even check for
duplicates, as I think you don't really want that, right?
It'd be also run faster.

--strk;