Michael Fuhr <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanlyThank you very much, you've been a great help.
Regards
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!