[pgpointcloud] PC_Get array of dimensions

[Lars]

Hello,

Does pgpointcloud have any plans to add a generic PC_Get function that accepts an array of input names? There was a discussion on the subject a while back but cannot see any new function. http://lists.osgeo.org/pipermail/pdal/2014-November/000429.html

The suggested function would make the query more compact and easier to read. Could it also improve performance?

A simple query without PC_Get/PC_Explode takes 1 ms.
select id from import where PC_Intersects(...);

Updating the test to include X value and the time increases to 21 ms.
select PC_Get(PC_Explode(pa), 'X') from import where PC_Intersects(...);

Updating the test to include X and Y and it takes 34ms.
select PC_Get(PC_Explode(pa), 'X'), PC_Get(PC_Explode(pa), 'Y')  from import where PC_Intersects(...);

Updating the test to include X,Y and Z and it takes 46ms.
select PC_Get(PC_Explode(pa), 'X'), PC_Get(PC_Explode(pa), 'Y'), PC_Get(PC_Explode(pa), 'Z')  from import where PC_Intersects(...);

It appear that for each dimension added the time increase quiet a bit. This is obviously a very simple test but just wanted to get a feedback.

Using Windows 7, PostgresSQL 10.3 and PostGIS 2.4.4

kind regards, Lars
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20180508/1df441e6/attachment.html>