Re: [SQL] best way to swap two records (computer details)

2005-03-23 Thread Michael Long
> 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; >> >>

[SQL] Function returns error

2004-06-10 Thread Michael Long
Hi All, I am a relatively new user to postgres. I have created a function that compiles but generates an error when executed. I know I am overlooking something simple. The function and error are below. CREATE OR REPLACE FUNCTION building_insert(varchar, int4, varchar) RETURNS int4 AS ' /* Retu