@Paul, that's what I thought, but it seems querry can't be un-rolled like
this,
because one row will have only one key.
(no one row will match all the conditions, you have to get several rows and
perform intersection of results).
I fully agree this is totally bad for postgres, I would guess Arjen
Yes, this works nicely. Thanks! Didn’t know about the ‘WITH’ statement
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Rémi Cura
Sent: vrijdag 16 december 2016 18:33
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Query
> On Dec 19, 2016, at 10:20 AM, Giuseppe Broccolo
> wrote:
>
> Hi,
>
> 2016-12-18 21:40 GMT+01:00 Puneet Kishor :
>> As advised, I downloaded and installed Postgress.app (Mac OS X Sierra with
>> Xcode 8.1). All works well.
>>
>>
Hi,
2016-12-18 21:40 GMT+01:00 Puneet Kishor :
> As advised, I downloaded and installed Postgress.app (Mac OS X Sierra with
> Xcode 8.1). All works well.
>
> However, I'd like to install and experiment with the pointcloud extension
> as I have a bunch of data from a 3D scan.