Re: returning the primary key value

hi,

If this primary key is a guid or a number that you create as unique, create it local to your function and then return the same after inserting within the function.

create or replace function test_insert() returns guid as $$
DECLARE
 ret guid;
BEGIN
   select into ret newid();
   -- ret is the primary key for the table "Table_a"
   insert into table_a (ret, "Value1","Value2");
  if not found then
     ..............
  end if;
  return ret;
END;
$$ language plpgsql;

your question is too abstract, i tink we will nee more information to solve your problem

vish