[pgpointcloud] PC_NumPoints

[Lars]

Hello list,

The query (below) produces count equal 1  as expected.
select pc_numpoints(pc_filterbetween(pa, 'x', 100.4140, 100.4151)) as count from testdata;

Tweaking the query slightly and the query produces count equal " " (no number displayed). The expected count is 0.
select pc_numpoints(pc_filterbetween(pa, 'x', 100.4140, 100.4150)) as count from testdata;

It looks like a bug that pc_numpoints is able to return a non-integer value.

This issue also applies to PC_PatchXXX functions that also return " " (no number) in the case the input is empty. Not sure what the correct return value should be in these cases.

Just a minor thing, it would be nice if the documentation for PC_FilterBetween made it clear that between means greater than value1 and less than values2. I made the mistake of thinking it was greater than or equal to value1 and less than or equal to value2.

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