getting at sequence previous/next values - Mailing list pgsql-sql

From Louis-David Mitterrand
Subject getting at sequence previous/next values
Date
Msg-id 20070226181451.GA9015@apartia.fr
Whole thread Raw
List pgsql-sql
Hello,

I've got a table that looks basically like:
id_show         | serialshow_name       | text show_type       | text                        created_on      |
timestampwithout time zone 
 

When looking at a row with an id_show of value n, I'd like to have an 
easy way of knowing the preceding and next values of id_show in the 
sequence (which might have holes).

Is there some convenient way to get that info, or must I do a full-blown 
select?

Thanks,


pgsql-sql by date:

Previous
From: "Rommel the iCeMAn"
Date:
Subject: Re: Change Default Database
Next
From: "Rodrigo De León"
Date:
Subject: Re: Change Default Database