Re: how to reset serials

On Thu, Jun 06, 2002 at 20:03:49 -0400,
Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)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);