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
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"
Show quoted text
From: "mike" <matrix@quadrent.net>
Date: Fri, 5 Oct 2001 15:07:10 -0400
To: <pgsql-general@postgresql.org>
Subject: [GENERAL] resequencing an existing sequenceI'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