[postgis-users] Storing geometries in variables

[ruvenml at beamerbrooks.com]

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, <ruvenml at beamerbrooks.com 
> <mailto:ruvenml at beamerbrooks.com>> 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
>>     postgis-users at lists.osgeo.org  <mailto:postgis-users at lists.osgeo.org>
>>     https://lists.osgeo.org/mailman/listinfo/postgis-users  <https://lists.osgeo.org/mailman/listinfo/postgis-users>
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>     https://lists.osgeo.org/mailman/listinfo/postgis-users
>     <https://lists.osgeo.org/mailman/listinfo/postgis-users>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200821/53b530be/attachment.html>