Re: how to reset serials

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);