Re: Sequences in transaction

From: Mike Castle <dalgoda(at)ix(dot)netcom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Sequences in transaction
Date: 2000-12-05 18:01:38
Message-ID: 20001205120138.D17698@thune.mrc-home.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 05, 2000 at 12:03:40PM -0500, Camm Maguire wrote:
> need to be able to *quickly* select a pair of *adjacent* rows in a
> table. t2.seq = t1.seq + 1 seems to work pretty well. Of course, I

What's wrong with a select ... order by .. limit 2 ?

mrc
--
Mike Castle Life is like a clock: You can work constantly
dalgoda(at)ix(dot)netcom(dot)com and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc
We are all of us living in the shadow of Manhattan. -- Watchmen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nico D 2000-12-05 18:19:51 Re: inheritance and foreign keys
Previous Message Andrew Perrin - Demography 2000-12-05 17:40:10 postmaster does not start up