Adam Haberlach <adam(at)newsnipple(dot)com> writes:
> I'm trying to find the next value that will be assigned by a sequence
> without actually incrementing it (yes, I know it isn't atomic-safe
> and all)
If you aren't very concerned about cross-transaction safety,
select last_value + increment_by from seq;
is approximately right.
There is a *lot* of discussion about this in the mailing list archives.
regards, tom lane