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 |