<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Helvetica, Arial, sans-serif"><br>
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.<br>
<br>
Ruven Brooks<br>
<br>
</font>
<div class="moz-cite-prefix">On 8/21/2020 11:18 AM, Shaozhong SHI
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CA+i5JwbpSWNZdzVeWOyWjEwmKe8SrLyH-bSwxFrq+JGKrYvVhA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi, Ruven Brooks,
<div><br>
</div>
<div>This is a good point.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div>Shao</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, 21 Aug 2020 at 15:32,
<<a href="mailto:ruvenml@beamerbrooks.com"
moz-do-not-send="true">ruvenml@beamerbrooks.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div> <font face="Helvetica, Arial, sans-serif">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.<br>
<br>
Ruven Brooks<br>
</font><br>
<div>On 8/21/2020 7:54 AM, Shaozhong SHI wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Has anyone got experience in storing
geometries in variables, so that these can be used in a
program?
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div>Shao</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>