<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Gavin,<div><span class="Apple-tab-span" style="white-space:pre"> </span>this kind of statements worked for Java H2DB - not sure about postgres...</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; color: rgb(78, 146, 146); ">-- WORKFLOW INSTANCE TYPE</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span style="color: #941067">CREATE</span> <span style="color: #941067">TABLE</span> IF <span style="color: #941067">NOT</span> <span style="color: #941067">EXISTS</span> WORKFLOW_INSTANCE_TYPE (</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; color: rgb(148, 16, 103); ">TYPE<span style="color: #000000"> </span><span style="color: #5a23ce">INT</span><span style="color: #000000"> </span>PRIMARY<span style="color: #000000"> </span>KEY<span style="color: #000000"> </span>NOT<span style="color: #000000"> </span><span style="color: #5a23ce">NULL</span><span style="color: #000000">,</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">DESCRIPTION <span style="color: #941067">VARCHAR</span>(200) <span style="color: #941067">NOT</span> <span style="color: #5a23ce">NULL</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">);</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">MERGE <span style="color: #941067">INTO</span> WORKFLOW_INSTANCE_TYPE (<span style="color: #941067">TYPE</span>, DESCRIPTION ) <span style="color: #941067">VALUES</span> (1, <span style="color: #2d2cfa">'DESDynI Standard'</span>);</div><div><br></div><div>Luca</div><div><br></div><div><div>On Feb 4, 2011, at 10:45 AM, Gavin M. Bell wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<div bgcolor="#ffffcc" text="#000000">
Hey SQL Mavens...<br>
<br>
Does anyone know how to create idempotent SQL scripts?<br>
If something is there already, then don't create it... <br>
If it is not, then do so.<br>
(the pithier the better)<br>
<br>
Thanks<br>
<pre class="moz-signature" cols="72">--
Gavin M. Bell
Lawrence Livermore National Labs
--
"Never mistake a clear view for a short distance."
-Paul Saffo
(GPG Key - <a class="moz-txt-link-freetext" href="http://rainbow.llnl.gov/dist/keys/gavin.asc">http://rainbow.llnl.gov/dist/keys/gavin.asc</a>)
A796 CE39 9C31 68A4 52A7 1F6B 66B7 B250 21D5 6D3E
</pre>
</div>
_______________________________________________<br>GO-ESSP-TECH mailing list<br><a href="mailto:GO-ESSP-TECH@ucar.edu">GO-ESSP-TECH@ucar.edu</a><br>http://mailman.ucar.edu/mailman/listinfo/go-essp-tech<br></blockquote></div><br></div></body></html>