From c622b0f59d1b6270ca7cc7acc0fec437161b1d73 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Wed, 28 Mar 2007 23:44:13 +0000
Subject: [PATCH] added example for expressions in updates

---
 doc/build/content/sqlconstruction.txt | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/doc/build/content/sqlconstruction.txt b/doc/build/content/sqlconstruction.txt
index 6584f3d64d..c5ccff559b 100644
--- a/doc/build/content/sqlconstruction.txt
+++ b/doc/build/content/sqlconstruction.txt
@@ -909,6 +909,11 @@ Updates work a lot like INSERTS, except there is an additional WHERE clause that
     UPDATE users SET password=users.user_name
     {}
     
+    # expressions OK too
+    {sql}users.update(values={users.c.user_id:users.c.user_id + 17}).execute()
+    UPDATE users SET user_id=users.user_id + :users_user_id
+    {'users_user_id':17}
+    
     # multi-update
     {sql}users.update(users.c.user_id==bindparam('id')).execute(
             {'id':7, 'user_name':'jack', 'password':'fh5jks'},
-- 
2.47.2