> I think you should just go with what Vadim suggested and use:
> select currval('my_sequence');
> This will be the same within a transaction, even if there is another
> transaction using the same sequence.
Sorry, I wasn't thinking of it happening in the same transaction. In that
case that would be the thing to do. If on the other hand you needed that
number over multiple transactions, wouldn't what I had suggested work?
...james
>