Re: Statistics from Sequences

Michael Fuhr <mike(at)fuhr(dot)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(at)postgresql(dot)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!