Re: SERIAL type fields

On Thu, Apr 24, 2003 at 12:43:24 -0700,
  Andrew Ayers <aayers@eldocomp.com> wrote:
> 
> What I came across was that I wanted to reset the sequence number so 
> that when the new records were added, they would start at number "1" and 
> increase from there.

If you look at the documentation for setval, you will see that there is
an optional third argument that you can use to keep the value from
being incremented on the next nextval call.