Thread: Is this possible?

Is this possible?

From
"Wei Weng"
Date:
I have a table that has a serial for primary key. Is it possible to get
the new available primary key right after I insert a row of new entry?

Thanks

Wei


Re: Is this possible?

From
Roberto Mello
Date:
On Tue, May 08, 2001 at 09:16:56PM -0400, Wei Weng wrote:
> I have a table that has a serial for primary key. Is it possible to get
> the new available primary key right after I insert a row of new entry?
Yeah. Se the documentation on triggers.
-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net      http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
 
"Data! I thought you were dead!" "No, Sir. I rebooted."