> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Erwin Ambrosch
> 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);
Nope. A select statement isn't itself a valid argument to a function. Turn
it into a subselect with parens:
SELECT setval('seq_name', ( SELECT max(id) FROM a_table ) );
- J.
Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant