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, <[email protected]> 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, <[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 >> [email protected]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 > [email protected]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
