This question and answer seem like a good candidate to add to the FAQ... <div class="gmail_quote">On Mon, Sep 14, 2009 at 8:45 PM, James Henstridge <<a href="mailto:james@jamesh.id.au">james@jamesh.id.au</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">On Mon, Sep 14, 2009 at 7:16 PM, Eduardo Willians<<a href="mailto:edujurista@gmail.com">edujurista@gmail.com</a>> wrote: > Did I say something wrong or stupid? </div>Nope. No one got round to answering the question though :( I'll rectify that now. <div class="im"> > > 2009/9/9 Eduardo Willians <<a href="mailto:edujurista@gmail.com">edujurista@gmail.com</a>>: >> Is there a stormic way to execute the following SQL statement? >> >> store.execute("""SELECT MAX(id) FROM gear.op WHERE CAST(id AS >> character) LIKE '9%';""").get_one() >> >> I'm using postgres. </div>There isn't anything in Storm to generate the WHERE clause you've used here. However, you can insert arbitrary SQL into an expression using the SQL() operator. Something like this: result = store.find(GearOp, SQL("CAST(<a href="http://gear.op.id" target="_blank">gear.op.id</a> AS character) LIKE '9%'")) maximum = result.max(GearOp.id) You can combine SQL() with other Storm expression objects in pretty much any situation. The one downside is that they won't give you the "auto tables" behaviour where Storm guesses what tables need to be used for a given query. It wasn't required in the above, because the table used in the SQL() expression is already referenced. If you want to keep the "auto tables" behaviour in other cases, you can manually specify what tables the expression uses. Something like: SQL("...", tables=[GearOp]) I hope this helps, James. <div><div></div><div class="h5"> -- storm mailing list <a href="mailto:storm@lists.canonical.com">storm@lists.canonical.com</a> Modify settings or unsubscribe at: <a href="https://lists.ubuntu.com/mailman/listinfo/storm" target="_blank">https://lists.ubuntu.com/mailman/listinfo/storm</a> </div></div></blockquote></div> -- ZeOmega Open Minds' Open Solutions 3010 Gaylord Parkway, Ste. 210 Frisco TX, 75034 <a href="http://www.zeomega.com">http://www.zeomega.com</a> Brad Allen 214-618-9880 (ext. 8006)