Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group