Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Select START and MAXVALUE from Sequence
Date
Msg-id 15049.1233070373@sss.pgh.pa.us
Whole thread Raw
In response to Re: Select START and MAXVALUE from Sequence  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Select START and MAXVALUE from Sequence  ("Lukas" <lukas@fmf.vtu.lt>)
List pgsql-novice
Tree view 
"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
> In response to Lukas :
>> But what about start value? I tryed to select start_value but no luck..

> min_value = start_value.

Well, that's typically but not necessarily true.

FYI, 8.4 and beyond will store the start_value separately.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Lukas"
Date:
Subject: Re: Select START and MAXVALUE from Sequence
Next
From: "Lukas"
Date:
Subject: Re: Select START and MAXVALUE from Sequence