Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Guettler
Subject Re: Get block of N numbers from sequence
Date
Msg-id 4A13AA77.40400@tbz-pariv.de
Whole thread Raw
In response to Get block of N numbers from sequence  (Thomas Guettler <hv@tbz-pariv.de>)
Responses Re: Get block of N numbers from sequence  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 

Thomas Guettler schrieb:
> Hi,
>
> how can you get N numbers (without holes) from a sequence?
>

If sequences could be locked like tables, it would be easy.

In old versions of postgres it worked:
  http://archives.postgresql.org//pgsql-hackers/2001-10/msg00930.php

 Thomas

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de

pgsql-general by date:

Previous
From: Thomas Guettler
Date:
Subject: Re: Get block of N numbers from sequence
Next
From: Gilles
Date:
Subject: [Windows] Feedback on PG?