Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating exponential sequences - Mailing list pgsql-novice

From Tom Lane
Subject Re: Creating exponential sequences
Date
Msg-id 28533.1034046788@sss.pgh.pa.us
Whole thread Raw
In response to Creating exponential sequences  (Rod Kreisler <rod@23net.net>)
Responses Re: Creating exponential sequences  (Rod Kreisler <rod@23net.net>)
List pgsql-novice
Tree view 
Rod Kreisler <rod@23net.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

pgsql-novice by date:

Previous
From: Rod Kreisler
Date:
Subject: Creating exponential sequences
Next
From: Rod Kreisler
Date:
Subject: Re: Creating exponential sequences