On Oct 19, 5:02 pm, David Lee <[email protected]> wrote: > Hey guys, > > How would you issue an UPDATE ... FROM ... statement with a Model > subclass or a Dataset instance? UPDATE ... FROM ... for PostgreSQL is > described here:http://www.postgresql.org/docs/8.2/static/sql-update.html.
UPDATE ... FROM is a PostgreSQL extension, not standard SQL. I think one of the other adapters supports it though (mssql?). I wouldn't have a problem accepting a patch that adds support to the PostgreSQL adapter for this. I'm not sure if there are semantics that many databases share for this type of action. If there is and I'm just not aware of it, it's possible the support could be built into the main Dataset class. Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
