Postgres Pro
Downloads
Home   >   mailing lists

Re: Get block of N numbers from sequence - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Get block of N numbers from sequence
Date
Msg-id 2f4958ff0905190459v6063e08coc9bdb630eb3356e5@mail.gmail.com
Whole thread Raw
In response to Get block of N numbers from sequence  (Thomas Guettler <hv@tbz-pariv.de>)
List pgsql-general
Tree view 
On Tue, May 19, 2009 at 12:45 PM, Thomas Guettler <hv@tbz-pariv.de> wrote:
> Hi,
>
> how can you get N numbers (without holes) from a sequence?

generate_series(), or make sure there's only one connection, no
transactions rollback.



--
GJ

pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Re: Where is tsearch2.sql
Next
From: Sebastien FLAESCH
Date:
Subject: Re: INTERVAL data type and libpq - what format?