Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Bruce MomjianDate: 2005-03-15 22:38:00
Subject: Re: fetching text file from internet
Previous:From: Dario BilloDate: 2005-03-15 21:30:49
Subject: fetching text file from internet

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group