Обсуждение: resequencing an existing sequence

Поиск
Список
Период
Сортировка

resequencing an existing sequence

От
"mike"
Дата:
I'm currently working on an online application that uses a sequence to
order the layout of blocks of text, but I've come to a problem when
someone adds blocks of text between existing blocks. I'm wondering if there
is any way to resequence an existing sequence to accommodate the new blocks
of text.
 
Mike
 
 

Re: resequencing an existing sequence

От
Keary Suska
Дата:
See setval(), nextval(), and currval() in the documentation on how to modify
sequences on the fly.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: "mike" <matrix@quadrent.net>
> Date: Fri, 5 Oct 2001 15:07:10 -0400
> To: <pgsql-general@postgresql.org>
> Subject: [GENERAL] resequencing an existing sequence
>
>
> I'm currently working on an online application that uses a sequence to
> order the layout of blocks of text, but I've come to a problem when
> someone adds blocks of text between existing blocks. I'm wondering if there
> is any way to resequence an existing sequence to accommodate the new blocks
> of text.
>
> Mike