insert into big_table (list of stuff)<br>select "list of stuff" from temp_table right outer join Big_ID_table right join little_table<br>where stuff.value > coalesce((select value with a series of case statements to define other other subselects),(select different value using different case statements),0)<br>
<br>I don't think I'm going to spend anymore time on the graphic version and instead just focus on the text portion. <br>The assumption is the possession of reading skills.<br><br><div class="gmail_quote">On Wed, Mar 3, 2010 at 10:03 AM, William Fragakis <span dir="ltr"><<a href="mailto:william@fragakis.com">william@fragakis.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">How sophisticated are the pointy heads?<br>
<br>
Is this a basic tutorial in sql syntax or do they want to visualize more<br>
complex queries?<br>
<br>
regards,<br>
<font color="#888888">William<br>
</font><div><div></div><div class="h5"><br>
On Tue, 2010-03-02 at 16:09 -0500, Jim Kinney wrote:<br>
> I need to make pictures of my postgresql queries fro the pointy-haired<br>
> boss types. I have Dia which I've used extensively to document the<br>
> logical flow of the application.<br>
> Now I need to produce a pictorial map of the logic of the actual sql<br>
> queries. google is not being helpful on this as I keep getting a<br>
> gazillion apps for making pictures of the database structure (that's<br>
> already done.).<br>
><br>
> The only thing I've seen is an example of using Venn Diagrams to<br>
> illustrate joins. OK. That makes loads of sense. But how do I<br>
> illustrate an insert or an update? Or the sub query based on date<br>
> string logic used as the source data for the insert's join call?<br>
><br>
> --<br>
> --<br>
> James P. Kinney III<br>
> Actively in pursuit of Life, Liberty and Happiness<br>
><br>
</div></div><div><div></div><div class="h5">> _______________________________________________<br>
> Ale mailing list<br>
> <a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
> <a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
> See JOBS, ANNOUNCE and SCHOOLS lists at<br>
> <a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br>
<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>-- <br>James P. Kinney III<br>Actively in pursuit of Life, Liberty and Happiness <br><br>