X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 58086D1B539 for ; Fri, 15 Aug 2003 09:33:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 26761-02 for ; Fri, 15 Aug 2003 06:33:30 -0300 (ADT) Received: from dmhi.ct.ro (dmhi.ct.ro [193.226.151.66]) by svr1.postgresql.org (Postfix) with ESMTP id 286F0D1C4B8 for ; Fri, 15 Aug 2003 06:33:27 -0300 (ADT) Received: from [192.168.1.114] (helo=aaa) by dmhi.ct.ro with smtp (Exim 3.03 #1) id 19nb0y-0002WH-00 for pgsql-sql@postgresql.org; Fri, 15 Aug 2003 12:36:56 +0300 Message-ID: <006601c36310$29da3a20$7201a8c0@dmhi.ct.ro> From: "cristi" To: Subject: sequence Date: Fri, 15 Aug 2003 12:32:36 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200308/189 X-Sequence-Number: 14805 What is wrong here? insert into table_name (field_name) values (select setval('sequence_name')-1) as currval);