Re: Creating exponential sequences

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Kreisler <rod(at)23net(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Creating exponential sequences
Date: 2002-10-08 03:13:08
Message-ID: 28533.1034046788@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Rod Kreisler <rod(at)23net(dot)net> writes:
> Is there any way to create an exponential sequence rather than incremental?
> What I would like is a sequence that would start at 1 and grow exponentially
> by 2. (i.e. 1,2,4,8,16,32....)

A sequence that will bomb out after 32 or 64 increments seems of limited
use ...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rod Kreisler 2002-10-08 03:13:24 Re: Creating exponential sequences
Previous Message Rod Kreisler 2002-10-08 02:52:04 Creating exponential sequences