Re: Select START and MAXVALUE from Sequence

From: "Lukas" <lukas(at)fmf(dot)vtu(dot)lt>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Select START and MAXVALUE from Sequence
Date: 2009-01-27 15:28:36
Message-ID: 29027.217.117.29.29.1233070116.squirrel@fmf.vgtu.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


>> yes it works - select min_value, max_value from MySeq;
>> But what about start value? I tryed to select start_value but no luck..
>
> min_value = start_value.
> Why do need this value?

Well, start value is optional start position which allows to start
sequence in the middle of its interval.
We use start value, and now we need to select this value.. is it possible?

--
Lukas
UAB nSoft
http://www.nsoft.lt
Lukas at nsoft.lt
+370 655 10 655

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-01-27 15:32:53 Re: Select START and MAXVALUE from Sequence
Previous Message Wright, George 2009-01-27 15:25:19 overhead for statistics collector