On Wed, Mar 12, 2008 at 8:47 AM, Emi Lu <[EMAIL PROTECTED]> wrote: > Hello, > > May I know can "case when " used by update clause. If yes, how? > > I use one small Example, table: test > ============================= > id > == > 5 > 6 > 8 > > try to update test.id > > > update test > > case > when id =5 then SET id = 6 > end > ;
would this work: update test set id=5 where id=6; ??? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
