How do I use the functions to get data from sequence objects?
For example, I need to know what is the value of a serial field after inserting a new record; the one assigned to the record just inserted.
I have tried the psql interfase with the following:
select currval('restaurant.ordenes_clave_seq');
but I get a message telling me that "currval of sequence "ordenes_clave_seq" is not yet defined in this session.
Please advice.
Respectfully,
Jorge Maldonado