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 B782CD1B4E5 for ; Fri, 12 Sep 2003 07:08:54 +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 17803-08 for ; Fri, 12 Sep 2003 04:08:25 -0300 (ADT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id C7A07D1B51A for ; Fri, 12 Sep 2003 04:08:23 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1) id 19xi2Z-000EZj-0Z; Fri, 12 Sep 2003 08:08:24 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 9DE3B168E3; Fri, 12 Sep 2003 08:08:22 +0100 (BST) Received: from mainbox.archonet.com (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with SMTP id EC87F1648F; Fri, 12 Sep 2003 08:08:21 +0100 (BST) Received: from 192.168.1.32 (SquirrelMail authenticated user dev) by mainbox.archonet.com with HTTP; Fri, 12 Sep 2003 08:08:22 +0100 (BST) Message-ID: <49234.192.168.1.32.1063350502.squirrel@mainbox.archonet.com> In-Reply-To: <001d01c378d9$d8a8bfc0$df6c32d2@athlon2000> References: <20030911194512.Q47864-100000@megazone.bigpanda.com> <001d01c378d9$d8a8bfc0$df6c32d2@athlon2000> Date: Fri, 12 Sep 2003 08:08:22 +0100 (BST) Subject: Re: How do I replace select ... into commands? From: "Richard Huxton" To: "Richard Sydney-Smith" Cc: "Stephan Szabo" , pgsql-sql@postgresql.org User-Agent: SquirrelMail/1.4.0 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 Importance: Normal X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/95 X-Sequence-Number: 15073 > Stephen replied : > >> Something like the above should work, what's the exact function and >> error >> message and what version are you using? >> >> > thanks Stephen. > > Exact function definition follows: > PG Version is 7.3.1 on Windows 2000 > select "max"(seq_val) as m into lastrsn from fseqkeys where seq_key = tbl; Slight change of syntax needed: select into recordvar max(seq_val) from ... - Richard Huxton