Re: [SQL] Re: Using the IN predicate in an UPDATE... - Mailing list pgsql-sql

> This query takes 20 years (poetic licence invoked ;-).
> Do you have a smarter way to accomplish this end:
>
> UPDATE table1 SET id = 2
> WHERE rec_num IN
>  ( SELECT rec_num
>    FROM table1
>    WHERE id = 1
>   );

I think the urge to do everything you might need inside the server can be disabling. I would export the table to a
file,fix it (with perl, sed, whatever) and import it back again. 

--Gene