[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