Re: Select START and MAXVALUE from Sequence - Mailing list pgsql-novice

From Lukas
Subject Re: Select START and MAXVALUE from Sequence
Date
Msg-id 29027.217.117.29.29.1233070116.squirrel@fmf.vgtu.lt
Whole thread Raw
In response to Re: Select START and MAXVALUE from Sequence  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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.


pgsql-novice by date:

Previous
From: "Wright, George"
Date:
Subject: overhead for statistics collector
Next
From: Tom Lane
Date:
Subject: Re: Select START and MAXVALUE from Sequence