X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id AABBDD8ABE
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Sep 2005 17:53:29 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 23035-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Sep 2005 20:53:26 +0000 (GMT)
Received: from web50602.mail.yahoo.com (web50602.mail.yahoo.com
	[206.190.38.89])
	by svr1.postgresql.org (Postfix) with SMTP id B837DD8AB9
	for <pgsql-sql@postgresql.org>; Thu,  8 Sep 2005 17:53:25 -0300 (ADT)
Received: (qmail 15634 invoked by uid 60001); 8 Sep 2005 20:53:27 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=TqYTWcdIoxi2I+fIZ3Mvsi8dZt6j7YnxlhuAagJAkyhh75jnCISPVUUjfJdHltHjTbBmAwX92S2RQPZNXGp5XABuP+1dL4BC/wPZG38srcbkYkovoP/ruUAtWrqaE6E6HqnPp7vOYu1kFVqeLgpxitjZz/3iENhfHN9VgUcRnX4=
	;
Message-ID: <20050908205327.15632.qmail@web50602.mail.yahoo.com>
Received: from [62.48.215.253] by web50602.mail.yahoo.com via HTTP;
	Thu, 08 Sep 2005 17:53:27 ART
Date: Thu, 8 Sep 2005 17:53:27 -0300 (ART)
From: =?iso-8859-1?q?Jo=FFffffffffffe3o=20Carvalho?=
	<joaocarvalho127@yahoo.com.br>
Subject: Re: Statistics from Sequences
To: pgsql-sql@postgresql.org
In-Reply-To: <20050908200801.GA84186@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1208037186-1126212807=:15087"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.196 required=5 tests=[AWL=-0.199,
	DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516, HTML_20_30=0.504,
	HTML_MESSAGE=0.001]
X-Spam-Level: *
X-Archive-Number: 200509/89
X-Sequence-Number: 22636

--0-1208037186-1126212807=:15087
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit



Michael Fuhr <mike@fuhr.org> escreveu:
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]

On Thu, Sep 08, 2005 at 02:32:12PM -0300, Joÿffffffffffe3o Carvalho wrote:
> Can you give me a help about:
> 
> > The min value
> > The max value
> > The increment value
> > The last used number

The example I posted shows how to obtain those values:

CREATE SEQUENCE fooseq;
SELECT * FROM fooseq;

If you want only particular columns then specify them:

SELECT min_value, max_value, increment_by, last_value FROM fooseq;

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


Thank you very much, you've been a great help.

Regards


		
---------------------------------
 Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!
--0-1208037186-1126212807=:15087
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV><BR><BR><B><I>Michael Fuhr &lt;mike@fuhr.org&gt;</I></B> escreveu:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<P>[Please copy the mailing list on replies so others can participate<BR>in and learn from the discussion.]<BR><BR>On Thu, Sep 08, 2005 at 02:32:12PM -0300, Joÿffffffffffe3o Carvalho wrote:<BR>&gt; Can you give me a help about:<BR>&gt; <BR>&gt; &gt; The min value<BR>&gt; &gt; The max value<BR>&gt; &gt; The increment value<BR>&gt; &gt; The last used number<BR><BR>The example I posted shows how to obtain those values:<BR><BR>CREATE SEQUENCE fooseq;<BR>SELECT * FROM fooseq;<BR><BR>If you want only particular columns then specify them:<BR><BR>SELECT min_value, max_value, increment_by, last_value FROM fooseq;<BR><BR>-- <BR>Michael Fuhr<BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 1: if posting/reading through Usenet, please send an appropriate<BR>subscribe-nomail command to majordomo@postgresql.org so that your<BR>message can get through to the mailing list cleanly<BR></P>
<P>Thank you very much, you've been a great help.</P>
<P>Regards</P></BLOCKQUOTE></DIV><p>
		<hr size=1> 
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. <a href="http://us.rd.yahoo.com/mail/br/taglines/*http://br.yahoo.com/messenger/promocao/">Participe!</a>
--0-1208037186-1126212807=:15087--