<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffcc" text="#000000">
Hi, <br>
<br>
:-(<br>
I tried that... it doesn't work for postgres :-|.<br>
I am trying to find the analogous command for postgres.<br>
<br>
(maybe we should just use H2...) ;-).<br>
<br>
<br>
On 2/4/11 9:50 AM, Cinquini, Luca (3880) wrote:
<blockquote
cite="mid:D2BE8425-FB43-4789-AD71-7DD367C9D705@jpl.nasa.gov"
type="cite">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: 0px; font: 11px Monaco; color: rgb(78, 146,
146);">-- WORKFLOW INSTANCE TYPE</div>
<div style="margin: 0px; font: 11px Monaco;"><span style="color:
rgb(148, 16, 103);">CREATE</span> <span style="color:
rgb(148, 16, 103);">TABLE</span> IF <span style="color:
rgb(148, 16, 103);">NOT</span> <span style="color: rgb(148,
16, 103);">EXISTS</span> WORKFLOW_INSTANCE_TYPE (</div>
<div style="margin: 0px; font: 11px Monaco; color: rgb(148, 16,
103);">TYPE<span style="color: rgb(0, 0, 0);"> </span><span
style="color: rgb(90, 35, 206);">INT</span><span
style="color: rgb(0, 0, 0);"> </span>PRIMARY<span
style="color: rgb(0, 0, 0);"> </span>KEY<span style="color:
rgb(0, 0, 0);"> </span>NOT<span style="color: rgb(0, 0,
0);"> </span><span style="color: rgb(90, 35, 206);">NULL</span><span
style="color: rgb(0, 0, 0);">,</span></div>
<div style="margin: 0px; font: 11px Monaco;">DESCRIPTION <span
style="color: rgb(148, 16, 103);">VARCHAR</span>(200) <span
style="color: rgb(148, 16, 103);">NOT</span> <span
style="color: rgb(90, 35, 206);">NULL</span></div>
<div style="margin: 0px; font: 11px Monaco;">);</div>
<div style="margin: 0px; font: 11px Monaco;">MERGE <span
style="color: rgb(148, 16, 103);">INTO</span>
WORKFLOW_INSTANCE_TYPE (<span style="color: rgb(148, 16,
103);">TYPE</span>, DESCRIPTION ) <span style="color:
rgb(148, 16, 103);">VALUES</span> (1, <span style="color:
rgb(45, 44, 250);">'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 moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:GO-ESSP-TECH@ucar.edu">GO-ESSP-TECH@ucar.edu</a><br>
<a class="moz-txt-link-freetext" href="http://mailman.ucar.edu/mailman/listinfo/go-essp-tech">http://mailman.ucar.edu/mailman/listinfo/go-essp-tech</a><br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<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>
</body>
</html>