Re: Get block of N numbers from sequence

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Thomas Guettler <hv(at)tbz-pariv(dot)de>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Get block of N numbers from sequence
Date: 2009-05-19 11:59:47
Message-ID: 2f4958ff0905190459v6063e08coc9bdb630eb3356e5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 19, 2009 at 12:45 PM, Thomas Guettler <hv(at)tbz-pariv(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sebastien FLAESCH 2009-05-19 12:17:20 Re: INTERVAL data type and libpq - what format?
Previous Message Howard Cole 2009-05-19 11:54:04 Re: Where is tsearch2.sql