Next and previous sequence values - Mailing list pgsql-novice

From Christopher Nehren
Subject Next and previous sequence values
Date
Msg-id slrnd3emjs.71a.apeiron+usenet@prophecy.dyndns.org
Whole thread Raw
Responses Re: Next and previous sequence values
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have a table whose rows are distinguished by a sequence. I'd like to
be able to, given a certain value of that sequence, retrieve the next
and previous values in relation to the given value. Couldn't find
anything in the docs for the version that I'm running, 8.0. Thanks in
advance.

Best Regards,
Christopher Nehren
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (FreeBSD)

iD8DBQFCN1p8k/lo7zvzJioRAuK7AJ475RloH+MyQ+BDq6a5STvqiTkzhgCeMhc5
G7RKiBriNAR/JugrxEy3yKI=
=U1Z1
-----END PGP SIGNATURE-----

--
I abhor a system designed for the "user", if that word is a coded
pejorative meaning "stupid and unsophisticated". -- Ken Thompson
If you ask the wrong questions, you get answers like "42" and "God".
Unix is user friendly. However, it isn't idiot friendly.

pgsql-novice by date:

Previous
From: Dario Billo
Date:
Subject: fetching text file from internet
Next
From: Bruce Momjian
Date:
Subject: Re: fetching text file from internet