Re: Question about setval() function - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Question about setval() function
Date
Msg-id 20020515004226.E10256@svana.org
Whole thread Raw
In response to Question about setval() function  (Erwin Ambrosch <ambre@ebutec.com>)
List pgsql-general
On Tue, May 14, 2002 at 04:18:47PM +0200, Erwin Ambrosch wrote:
> Hi,
>
> the following doesn't work.
>
> SELECT setval('int_article_id_seq', SELECT max(id) FROM int_article);

I'm just guessing, but what if you put ()'s around the subquery?

HTH,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America

pgsql-general by date:

Previous
From: tony
Date:
Subject: Re: Using COPY
Next
From: Tom Lane
Date:
Subject: Re: postmaster core dumps with SPI_repalloc