[pgpointcloud] how define schema to store double data?

Zhiyong Weng zhiyong.weng at gmail.com
Sun Nov 15 17:49:39 PST 2015


Hi All,

   I try to store double data like point(-127.12345678, 45.12345678,
124.012345678, 4.012345678), I want keep the full precision.
   and I define pc:interpretation is double,
   but when I get data from db,only get 6 precision double,like this:
SELECT PC_AsText(PC_MakePoint(8, ARRAY[-127.123456, 45.123456, 124.0123456,
4.0123456]));
*"{"pcid":8,"pt":[-127.123,45.1235,124.012,4.01235]}"*

   How shall I define the schema? Thanks.

  attached my schema file.

Regards,
Max
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20151116/32192a1e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pointcloud_4d_schema_double.sql
Type: application/sql
Size: 2033 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20151116/32192a1e/attachment.bin>


More information about the pgpointcloud mailing list