Re: [SQL] Statistics from Sequences

2005-09-08 Thread Michael Fuhr
[Again, please copy the mailing list on replies so others can participate in and learn from the discussion.] On Thu, Sep 08, 2005 at 06:25:33PM -0300, Joÿffe3o Carvalho wrote: > There's one thing. If the sequence name was fooseq in uppercase > (FOOSEQ) it does not work. In that case it ret

Re: [SQL] Statistics from Sequences

2005-09-08 Thread Joÿffffffffffe3o Carvalho
Michael Fuhr <[EMAIL PROTECTED]> escreveu: [Please copy the mailing list on replies so others can participatein and learn from the discussion.]On Thu, Sep 08, 2005 at 02:32:12PM -0300, Joÿffe3o Carvalho wrote:> Can you give me a help about:> > > The min value> > The max value> > The increm

Re: [SQL] Statistics from Sequences

2005-09-08 Thread Michael Fuhr
[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ÿffe3o Carvalho wrote: > Can you give me a help about: > > >The min value > >The max value > >The increment value > >The last u

Re: [SQL] Statistics from Sequences

2005-09-06 Thread Bruno Wolff III
On Tue, Sep 06, 2005 at 23:43:44 -0300, Joÿffe3o Carvalho <[EMAIL PROTECTED]> wrote: > Is it possible to get from a sequence: > >The sequence owner >The min value >The max value >The increment value >The last used number Yes. Associated with each sequence is a one ro

Re: [SQL] Statistics from Sequences

2005-09-06 Thread Michael Fuhr
On Tue, Sep 06, 2005 at 11:43:44PM -0300, Joÿffe3o Carvalho wrote: > Is it possible to get from a sequence: > >The sequence owner >The min value >The max value >The increment value >The last used number See the output from the following example: CREATE SEQUENCE fooseq