Thread: 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.
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" > 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