Re: [SQL] Interest IN problem on 7.4

Hi, thanks a lot. All is ok now. regards, ivan. Stephan Szabo wrote: > On Sat, 13 Dec 2003, pginfo wrote: > > > Hi, > > > > I am using pg 7.4. > > > > Pls, see this test: > > > > tt07=# update a_cars set dog_or_free=0 where virtualen=0 and > > dog_or_free=4 and ids NOT IN ( select oc.ids_car_rea

Re: [SQL] Interest IN problem on 7.4

On Sat, 13 Dec 2003, pginfo wrote: > Hi, > > I am using pg 7.4. > > Pls, see this test: > > tt07=# update a_cars set dog_or_free=0 where virtualen=0 and > dog_or_free=4 and ids NOT IN ( select oc.ids_car_real from a_oferti_cars > oc,a_oferti o where oc.IDS_oferti=o.ids and o.date_valid>=9964) A