Обсуждение: how to reset serials
how can i reset my serial field to 0. Tried using setval but it only allows setting of my next serial to 2 joseph
On Thu, Jun 06, 2002 at 20:03:49 -0400, Joseph Syjuco <joseph@asti.dost.gov.ph> wrote: > how can i reset my serial field to 0. Tried using setval but it only > allows setting of my next serial to 2 > joseph From the 7.2.1 documentation: SELECT setval('foo', 42); Next nextval() will return 43 SELECT setval('foo', 42, true); Same as above SELECT setval('foo', 42, false); Next nextval() will return 42 So you want to use (assuming you really want the next value to be 1): SELECT setval('your_sequence', 1, false);
thanks for the tip ... im close to dropping and recreating my table Bruno Wolff III wrote: > > On Thu, Jun 06, 2002 at 20:03:49 -0400, > Joseph Syjuco <joseph@asti.dost.gov.ph> wrote: > > how can i reset my serial field to 0. Tried using setval but it only > > allows setting of my next serial to 2 > > joseph > > >From the 7.2.1 documentation: > SELECT setval('foo', 42); Next nextval() will return 43 > SELECT setval('foo', 42, true); Same as above > SELECT setval('foo', 42, false); Next nextval() will return 42 > > So you want to use (assuming you really want the next value to be 1): > SELECT setval('your_sequence', 1, false);