Re: [Q]updating multiple rows with Different values

On Sun, Nov 23, 2008 at 8:43 AM, V S P <toreason@fastmail.fm> 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