The DO statement is not in standard SQL; it is a PostgreSQL extension
used to implement procedural languages like PL/SQL. Are you writing
PL/SQL code? If so, it would be useful to have an explanation of what
you are trying to compute, particularly if the computations are
geometric ones.
Ruven Brooks
On 8/21/2020 11:18 AM, Shaozhong SHI wrote:
Hi, Ruven Brooks,
This is a good point.
I was testing in a Do statement. I created a geometry variable. It
seems that it stored a geometry object. However, a very long code
appeared. It does not seem that the geometry object was not actually
stored.
Regards,
Shao
On Fri, 21 Aug 2020 at 15:32, <[email protected]
<mailto:[email protected]>> wrote:
SQL itself has no variables. What programming language are you
using and how does it call SQL? PosgGIS supports WKT format so
pretty much any programming language which can store strings can
store geometry.
Ruven Brooks
On 8/21/2020 7:54 AM, Shaozhong SHI wrote:
Has anyone got experience in storing geometries in variables, so
that these can be used in a program?
Regards,
Shao
_______________________________________________
postgis-users mailing list
[email protected] <mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
<https://lists.osgeo.org/mailman/listinfo/postgis-users>
_______________________________________________
postgis-users mailing list
[email protected] <mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
<https://lists.osgeo.org/mailman/listinfo/postgis-users>
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
