Hi,
Can anyone in the list tell me how to get the value in the lastvalue field
of a sequence. I tried
select currval('field_seq');
but got an error message
ERROR: currval of sequence "field_seq" is not yet defined in this session.
I think currval will work only after an insert. I don't want to use nextval
as this increases the lastvalue value.
Thanks in advance
Kind Regards,
Venki