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;
This isn't quite what I want. I want to SWAP the p_name and p_location
between the two records, not set them to static values.
Any help would be appreciated.
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
In response to
pgsql-sql by date
|Next:||From: Wei Weng||Date: 2005-03-23 17:37:54|
|Subject: How do I do this?|
|Previous:||From: Gary Stainburn||Date: 2005-03-23 17:26:06|
|Subject: Re: best way to swap two records (computer details)|