Re: [GENERAL] [Q]updating multiple rows with Different values

2008-11-23 Thread Scott Marlowe
On Sun, Nov 23, 2008 at 8:43 AM, V S P <[EMAIL PROTECTED]> wrote: > Thank you very much > this is exactly what I am looking for > > As well as the example provided > ' case when id=1 then 10 ' > > - it will work as well. > > > Now just one more question: > I will not have a lot of values to updat

Re: [GENERAL] [Q]updating multiple rows with Different values

2008-11-23 Thread V S P
Thank you very much this is exactly what I am looking for As well as the example provided ' case when id=1 then 10 ' - it will work as well. Now just one more question: I will not have a lot of values to update (less than a 1000 at a time) -- but the values for col1 will be text that is up t

Re: [GENERAL] [Q]updating multiple rows with Different values

2008-11-23 Thread Gerhard Heift
On Sat, Nov 22, 2008 at 10:04:48PM -0500, V S P wrote: > Hello, > searched documentation, FAQ and mailing list archives > (mailing list archive search is volumous :-) ) > > but could not find an answer: > > I would like to be able to update > several rows to different values at the same time > >

Re: [GENERAL] [Q]updating multiple rows with Different values

2008-11-23 Thread Andreas Kretschmer
V S P <[EMAIL PROTECTED]> schrieb: > Hello, > searched documentation, FAQ and mailing list archives > (mailing list archive search is volumous :-) ) > > but could not find an answer: > > I would like to be able to update > several rows to different values at the same time > > In oracle this use