Re: Re: update ... from where id in (..) question - Mailing list pgsql-general

Joel Burton <jburton@scw.org> writes:
>> update table set statusflag = 'U' where id in ('id10', 'id20',
>> 'id30');

> 1) Next time, try WHERE ID = 'id10' OR ID = 'id20' OR ... and see if
> that's better.

The former should in fact be automatically translated to the latter,
so that's not the issue here.

            regards, tom lane