Re: problem fetching currval of sequence

Tom,

> Are you sure you were not thinking of "select last_value from seq"?
> That's about the closest approximation I can think of to a
> non-transaction-safe version of currval().

Well, you are the authority.   And I'm not willing to regress my database
install just to figure it out.   Maybe I am thinking of "Select last_value".

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology     josh@agliodbs.com   and data management solutions     (415) 565-7293  for law firms, small
businesses     fax 621-2533   and non-profit organizations.     San Francisco