[postgis-users] Storing geometries in variables

[Shaozhong SHI]

Hi, Ruven Brooks,

I am trying to explore its potential and versatility.

Can standard SQL work like a program?

As I understand, DO statement is similar to a function.

What I am interested in is to fully understand its capabilities and working
like a program.

Working like to powerful program would allow data manipulation.

Have you tried writing DO statement with Python?

Regards,

Shao

On Fri, 21 Aug 2020 at 18:52, <ruvenml at beamerbrooks.com> wrote:

>
> 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> 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 listpostgis-users at lists.osgeo.orghttps://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
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttps://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/45bf32fe/attachment.html>