[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!