Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f2IJPbx51647 for ; Sun, 18 Mar 2001 14:25:37 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2GK9sx53339 for ; Fri, 16 Mar 2001 15:09:54 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2GK9ot25938; Fri, 16 Mar 2001 15:09:50 -0500 (EST) To: e.ellenkamp@copernicus-it.nl (Egbert Ellenkamp) cc: pgsql-sql@postgresql.org Subject: Re: update table sequence In-reply-to: <3ab203b3.242887724@newzilla.xs4all.nl> References: <3ab203b3.242887724@newzilla.xs4all.nl> Comments: In-reply-to e.ellenkamp@copernicus-it.nl (Egbert Ellenkamp) message dated "Fri, 16 Mar 2001 12:15:28 +0000" Date: Fri, 16 Mar 2001 15:09:50 -0500 Message-ID: <25935.984773390@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/343 X-Sequence-Number: 2007 e.ellenkamp@copernicus-it.nl (Egbert Ellenkamp) writes: > select setval('mytable_myrowid_seq',select max(myrowid) from mytable); That should work if you put in the required parentheses around the sub-select: select setval('mytable_myrowid_seq', (select max(myrowid) from mytable)); regards, tom lane