On Sun, Nov 23, 2008 at 8:43 AM, V S P <toreason@xxxxxxxxxxx> 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 update (less than a 1000 > at a time) -- but the values for col1 will be text that is > up to 64K. So I will not be able to construct SQL strings > and just send them (because it will probably exceed the character > limits for the SQL statements). There are no character limits for sql statements in pgsql -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
