Next and previous sequence values

From: Christopher Nehren <apeiron+usenet(at)coitusmentis(dot)info>
To: pgsql-novice(at)postgresql(dot)org
Subject: Next and previous sequence values
Date: 2005-03-15 21:57:05
Message-ID: slrnd3emjs.71a.apeiron+usenet@prophecy.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2005-03-15 22:38:00 Re: fetching text file from internet
Previous Message Dario Billo 2005-03-15 21:30:49 fetching text file from internet