Re: Re: update ... from where id in (..) question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joel Burton <jburton(at)scw(dot)org>
Cc: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: update ... from where id in (..) question
Date: 2001-05-03 01:36:42
Message-ID: 20975.988853802@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joel Burton <jburton(at)scw(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric G. Miller 2001-05-03 01:37:06 Re: big pg 6.5 and 7.1 problem in simple application
Previous Message Tom Lane 2001-05-03 01:35:18 Re: Tuple Max Size on 7.1