Received: from klay.imc ([216.18.11.61]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0IIaZ084810 for ; Thu, 18 Jan 2001 13:36:35 -0500 (EST) (envelope-from drfrog@smartt.com) Received: from smartt.com (IDENT:drfrog@localhost.localdomain [127.0.0.1]) by klay.imc (8.11.0/8.11.0) with ESMTP id f0IIbiK08535; Thu, 18 Jan 2001 10:37:48 -0800 Message-ID: <3A6737F7.A21FECA0@smartt.com> Date: Thu, 18 Jan 2001 10:37:43 -0800 From: clayton cottingham X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Najm Hashmi CC: "pgsql-sql@postgresql.org" Subject: Re: Selecting Current value from a sequence References: <3A688085.23E57E79@mondo-live.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/219 X-Sequence-Number: 885 Najm Hashmi wrote: > > Hi all, > It is a very simple but I am not able to recall how to do it.... I > just need to find out the current value of a seq. It is very simple > select statement but I can't recall it... Help me please before I get > myself get fired -:). > Regards, Najm select nextval('nameofseq');