I am trying to write a PSQL that inserts all the values into a table
except the record number.
I have a trigger that using a generator creates an incremental number
for each new record.

Is there a way to write the PSQL so that after it inserts the values
it selects the new record number (the one in my table, not the one in
the system tables) and returns it. I guess I'm asking how to select a
field value based on the cursors current position. Is that possible?

E. D. Epperson Jr