Postgres Pro
Downloads
Home   >   mailing lists

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

From Joel Burton
Subject Re: Question about setval() function
Date
Msg-id JGEPJNMCKODMDHGOBKDNCEDKCOAA.joel@joelburton.com
Whole thread Raw
In response to Question about setval() function  (Erwin Ambrosch <ambre@ebutec.com>)
List pgsql-general
Tree view 
> -----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

pgsql-general by date:

Previous
From: Jose Manuel Lorenzo Lopez
Date:
Subject: Problems compiling postgresql 7.2.1 on AIX
Next
From: Jeremy Buchmann
Date:
Subject: Re: [JDBC] select * from mytable where myfield=null;