This wont work because myvalue must be a record or row variable.
I'm guessing its nearly impossible to get the last inserted id from
access 2003 using
postgres odbc.
select @@IDENTITY always returns "2".
Thoughts?
create function last_insert_id(varchar,varchar ) returns integer
as '
declare
intable alias for $1;
incolumn alias for $2;
myvalue integer;
BEGIN
for myvalue in execute '' select currval('''' ''
|| intable || ''_'' || incolumn
|| ''_seq'''')
'' Loop
return myvalue;
END loop;
END;
'
language plpgsql;
--
With best regards,
Mike Fahey - Systems Administration
********************************************************************
ENTER.NET - "The Road to the Internet Starts Here!" (tm)
(610) 437-2221 * http://www.enter.net/ * email:support@enter.net
********************************************************************
