Here's what I'm really trying to do:
I want to insert a row; one of the items in the row is of
type SERIAL. After I insert the row, I want to know what
value was assigned to the SERIAL item, call it the f_id.
I'm doing this from a C program. I can get the oidvalue,
and it should be unique long enough for me to get the f_id.
once I have the f_id, i'm okay. I won't try to use the oid again.
Is there some way to get the just computed value for the SERIAL?
Do I need to select the f_id from files where oid=?
I can't figure out the select syntax if i do.
SELECT f_id FROM files WHERE ?? oid=8675309??
I'm in trouble after the WHERE.
j.
--
Jay Scott 512-835-3553 gl@arlut.utexas.edu
Head of Sun Support, Sr. Operating Systems Specialist
Applied Research Labs, Computer Science Div. S224
University of Texas at Austin