Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0IHs6077407 for ; Thu, 18 Jan 2001 12:54:06 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@ll20.local2.lan [192.168.2.20]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id QAA03899 for ; Thu, 18 Jan 2001 16:48:18 GMT Message-ID: <3A688085.23E57E79@mondo-live.com> Date: Fri, 19 Jan 2001 12:59:34 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Selecting Current value from a sequence Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/216 X-Sequence-Number: 881 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