-----Original Message-----
From: Erwin Ambrosch [mailto:ambre@ebutec.com]
Sent: Tuesday, May 14, 2002 10:19 AM
To: pgsql-general@postgresql.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;