Andy,<br><br>Am I correct in thinking that you are pointing out that while<br>(query &quot;select name from countries where id=$1&quot; 27)<br>((&quot;Singapore&quot;))<br><br>works<br><br>(query &quot;copy $1 to$2&quot; &quot;countries&quot; &quot;/home/sabra/test/test.dat&quot;)<br>
<br>does not work?<br><br>Sabra<br><br><div class="gmail_quote">On Fri, Nov 12, 2010 at 8:07 PM,  <span dir="ltr">&lt;<a href="mailto:achambers@mcna.net">achambers@mcna.net</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi,<br>
<br>
Am I correct in thinking that there is currently no way to parameterize raw SQL strings to be sent through postmodern?  I realize most SQL can be expressed as S-SQL but it doesn&#39;t seem to support COPY syntax yet.  I added the function `sql-fmt&#39; for this purpose and am submitting it to the list in case it&#39;s useful for others....<br>

<br>
(defun sql-fmt (fmt &amp;rest args)<br>
  (apply &#39;format nil fmt (mapcar &#39;sql-ize args)))<br>
<br>
In my repo [1], I added this to the :export list of both s-sql and postmodern packages.  Please pull the change or let me know if you need this changed in any way.<br>
<br>
[1]: <a href="https://github.com/cddr/Postmodern/commits/master" target="_blank">https://github.com/cddr/Postmodern/commits/master</a><br>
<br>
Cheers,<br>
Andy<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
postmodern-devel mailing list<br>
<a href="mailto:postmodern-devel@common-lisp.net">postmodern-devel@common-lisp.net</a><br>
<a href="http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel" target="_blank">http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel</a><br>
</blockquote></div><br>