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

[Tom van Tilburg]

Yes, you are totally correct. Me bad, should have known that.

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

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