Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 13B534767D0 for ; Wed, 11 Sep 2002 13:30:26 -0400 (EDT) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 24E75476769 for ; Wed, 11 Sep 2002 13:30:25 -0400 (EDT) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1644457; Wed, 11 Sep 2002 10:30:23 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "Beth Gatewood" , Subject: Re: writing a function to mimic mysql last_insert_id Date: Wed, 11 Sep 2002 10:30:46 -0700 X-Mailer: KMail [version 1.4] References: <000701c259b7$f68b3280$0c00000a@bethvizx> In-Reply-To: <000701c259b7$f68b3280$0c00000a@bethvizx> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200209111030.46289.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/81 X-Sequence-Number: 9358 Beth, > I am wondering if I can get some input on the logic that I would need to > code a function that would mimic mysql's last_insert_id().. Um, what about CURRVAL('sequence-name')? --=20 -Josh Berkus Aglio Database Solutions San Francisco