
Changes to Netezza Spatial
Changes to Netezza Spatial
Spatial precision has changed such that coordinate values display only the value's signifi-
cant digits up to fifteen digits of precision which is the maximum for 64-bit floating point val-
ues. Prior to 2.0, by default, the user would always see 16 decimal digits. This means that
any trailing 0's at the end of a value will now be truncated in this release. For example, pri-
or to this release the user would have seen the following:
INZA(ADMIN)=> select st_astext(st_wkttosql('point (10 16)'));
ST_ASTEXT
-------------------------------------------------
POINT (10.0000000000000000 16.0000000000000000)
(1 row)
With 2.0 they will now see:
INZA(ADMIN)=> select st_astext(st_wkttosql('point (10 16)'));
ST_ASTEXT
---------------
POINT (10 16)
(1 row)
Additionally, prior to this release, the user could control the number of decimal digits as fol-
lows:
INZA(ADMIN)=> select st_astext(st_wkttosql('point (10 16)'), 8);
ST_ASTEXT
---------------------------------
POINT (10.00000000 16.00000000)
(1 row)
With this release this option is no longer available.
17
Kommentare zu diesen Handbüchern