Re: Question about setval() function

-----Original Message-----
From: Erwin Ambrosch [mailto:ambre(at)ebutec(dot)com]
Sent: Tuesday, May 14, 2002 10:19 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Question about setval() function

> the following doesn't work.

> SELECT setval('int_article_id_seq', SELECT max(id) FROM int_article);

Try this instead:

SELECT setval('int_article_id_seq', max(id)) FROM int_article;