<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Bob,<br>
<br>
I would recommend something as simple as<br>
<br>
SELECT * from mytable where myfield = '@MYSTRING';<br>
<br>
I tried using a string variable in a PGScript once, too, and if I
remember correctly, quote_literal() did not work.<br>
<br>
Good luck and regards,<br>
<br>
Birgit<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">Am 24.09.2015 um 03:43 schrieb David
Fawcett:<br>
</div>
<blockquote
cite="mid:CAF7K3b8x=jEBPMWTa_B4hUOSNK=45tE0nM1xcjyS9wWRmoUodQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Bob, <br>
<br>
</div>
I haven't ever used PGScript, but I wonder one of the
postgres quote functions found on this page might work: <a
moz-do-not-send="true"
href="http://www.postgresql.org/docs/9.1/static/functions-string.html">http://www.postgresql.org/docs/9.1/static/functions-string.html</a><br>
<br>
</div>
I would try quote_literal()<br>
<br>
</div>
David.<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Sep 23, 2015 at 4:26 PM,
Bistrais, Bob <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:Bob.Bistrais@maine.gov" target="_blank">Bob.Bistrais@maine.gov</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal">I am having trouble using a
variable in a Select statement, using PGScript. I am
trying to define a string variable, then use it in the
Select statement. Something like this:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">DECLARE @MYSTRING;</p>
<p class="MsoNormal">SET @MYSTRING =
CAST(@REC[0]['mycode'] AS STRING); --@REC was set
from a previous select</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">SELECT * from mytable where myfield
= @MYSTRING;</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-The variable is not quoted, so the
select statement fails. How do I get the string
variable to be enclosed in quotes?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
</div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<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="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>