Re: best way to swap two records (computer details) - Mailing list pgsql-sql

> On Friday 18 March 2005 4:32 pm, you wrote:
>> How about a user defined function ???
>>
>> CREATE OR REPLACE FUNCTION harwareupdate(integer, integer) RETURNS
>> BOOLEAN AS '
>>
>>     update pieces set p_name = \'LSALES1\', p_location = \'Mike
>> Haley\', p_site = \'L\' where p_id = $1;
>>
>>     update pieces set p_name = \'SPARE\', p_location = \'spare\',
>> p_site = \'L\'
>>     where p_id = 2;
>>
>

Why not declare variables and select the current values into them and then update
the records with the appropriate values.