| PostgreSQL 9.3.2文鐃緒申 | ||||
|---|---|---|---|---|
| 鐃緒申鐃塾ペ￥申鐃緒申 | 鐃緒申鐃緒申鐃緒申 | 鐃緒申 9鐃熟関随申鐃夙演算鐃緒申 | 鐃緒申鐃塾ペ￥申鐃緒申 | |
鐃緒申鐃緒申鐃緒申鐃藷スワ申鐃瞬ワ申鐃緒申鐃緒申鐃夙￥申鐃緒申鐃緒申鐃緒申鐃藷スワ申鐃緒申鐃粛レー鐃緒申鐃夙わ申単鐃祝ワ申鐃緒申鐃緒申鐃藷スとわ申討个鐃暑、鐃緒申鐃緒申任鐃�鐃緒申鐃緒申鐃緒申鐃藷スワ申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃出わ申鐃初算鐃緒申圓鐃緒申愎鐃緒申砲弔鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鵐好鐃緒申屮鐃緒申鐃緒申鐃緒申箸鐃緒申端鐃淑逸申團董鐃緒申屮鐃叔￥申CREATE SEQUENCE鐃叔削申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鵐好鐃緒申屮鐃緒申鐃緒申鐃緒申箸楼鐃緒申鐃重�鐃祝テ￥申鐃瞬ワ申旅圓飽鐃春の種申鐃縮子わ申鐃緒申鐃緒申鐃緒申鐃暑た鐃緒申忙鐃緒申僂鐃緒申鐃殉わ申鐃緒申表9-41鐃緒申鐃緒申鵑気鐃銃わ申鐃暑シ鐃緒申鐃緒申鐃藷ス関随申鐃熟￥申鐃緒申鐃緒申鐃緒申鐃藷スワ申鐃瞬ワ申鐃緒申鐃緒申鐃夙わ申鐃緒申連続鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃粛わ申鐃緒申鐃緒申鐃緒申襪随申鐃塾￥申鐃淑易でマワ申鐃緒申罅種申鐃緒申鐃緒申弍鐃緒申鐃緒申鐃緒申愎鐃緒申任鐃緒申鐃�
表 9-41. 鐃緒申鐃緒申鐃緒申鐃藷ス関随申
| 鐃舜随申 | 鐃緒申鐃緒申鐃� | 鐃緒申鐃緒申 |
|---|---|---|
currval(regclass) | bigint | 鐃緒申鐃所さ鐃曙た鐃緒申鐃緒申鐃緒申鐃藷スわ申鐃出わ申nextval鐃緒申鐃緒申鐃緒申譴随申膿鐃緒申鐃緒申佑鐃緒申屬鐃� |
lastval() | bigint | 鐃宿わ申淵鐃緒申鐃緒申鐃緒申鵐垢鐃緒申个鐃緒申討任鐃�nextval鐃祝わ申鐃叔わ申廼鐃緒申鐃緒申鐃緒申鐃曙た鐃粛わ申鐃瞬わ申
|
nextval(regclass) | bigint | 鐃緒申鐃緒申鐃緒申鐃藷スわ申覆瓠�鐃緒申鐃緒申鐃緒申鐃粛わ申鐃瞬わ申 |
setval(regclass, bigint) | bigint | 鐃緒申鐃緒申鐃緒申鐃藷スの醐申鐃緒申鐃粛わ申鐃緒申鐃所す鐃緒申 |
setval(regclass, bigint, boolean) | bigint | 鐃緒申鐃緒申鐃緒申鐃藷スの醐申鐃緒申鐃粛わ申is_called鐃春ラグ鐃緒申鐃緒申鐃所す鐃緒申 |
鐃緒申鐃緒申鐃緒申鐃藷ス関随申鐃祝わ申鐃緒申鐃庶さ鐃緒申襯件申鐃緒申鐃緒申鵐垢鐃�regclass鐃緒申鐃緒申鐃叔誌申鐃所さ鐃曙、鐃緒申鐃緒申鐃銃わ申鐃緒申鐃�pg_class鐃緒申鐃緒申鐃銃ムカ鐃緒申鐃緒申鐃緒申鐃緒申離鐃緒申鐃緒申鐃緒申鵐垢鐃�OID鐃祝過ぎ鐃殉わ申鐃藷。種申鐃夙わ申OID鐃薯検削申鐃緒申鐃銃はわ申鐃緒申鐃殉わ申鐃藷が￥申regclass鐃叔￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃術器申鐃緒が鐃緒申鐃獣てわ申鐃塾削申箸鐃峻ってわ申鐃緒申泙鐃緒申鐃緒申鐃銃ワ申鐃舜随申鐃塾よう鐃祝醐申鐃緒申鐃暑す鐃緒申茲�鐃祝わ申鐃暑た鐃潤、単鐃緒申鐃緒申鐃緒申鐃叔鰹申鐃曙た鐃緒申鐃緒申鐃緒申鐃緒申名鐃薯記述わ申鐃緒申鐃緒申鐃緒申任鐃緒申鐃緒申名鐃緒申SQL鐃緒申名鐃塾でわ申鐃緒申鐃夙の互器申鐃塾わ申鐃潤、文鐃緒申鐃緒申魯鐃緒申鐃緒申鐃緒申鐃縮常申鐃緒申鐃重逸申鐃緒申鐃緒申燃鐃緒申鐃銃わ申鐃緒申奮鐃緒申鐃緒申鐃淑醐申鐃緒申鐃緒申儡鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申辰董鐃緒申焚鐃緒申里茲�鐃祝なわ申泙鐃緒申鐃�
nextval('foo') operates on sequence foo
nextval('FOO') operates on sequence foo
nextval('"Foo"') operates on sequence Foo必鐃竣でわ申鐃緒申弌鐃緒申焚鐃緒申里茲�鐃祝ワ申鐃緒申鐃緒申鐃緒申名鐃薯スワ申鐃緒申鐃殉で緒申鐃緒申鐃緒申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申
nextval('myschema.foo') operates on myschema.foo
nextval('"myschema".foo') same as above
nextval('foo') searches search path for fooregclass鐃祝関わ申鐃銃のわ申鐃旬細な常申鐃緒申鐃�鐃緒申8.18鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申
鐃緒申鐃緒申: PostgreSQL 8.1鐃緒申鐃緒申鐃祝わ申鐃緒申鐃銃は￥申鐃緒申鐃緒申鐃緒申鐃藷ス関随申鐃塾逸申鐃緒申鐃緒申regclass鐃緒申鐃叔はなわ申鐃緒申text鐃緒申鐃叔￥申鐃緒申鐃緒申鐃銃上記鐃塾テワ申鐃緒申鐃緒申文鐃緒申鐃藷かわ申OID鐃粛へわ申鐃術器申鐃熟わ申鐃曙ぞ鐃緒申慮討喀个鐃緒申孫垰鐃緒申傍鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃淳器申鐃緒申鐃塾わ申鐃潤、鐃緒申鐃塾誌申鐃夙みはまわ申存鐃淳わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申的鐃祝は関随申鐃緒申鐃渋行わ申鐃緒申鐃緒申鐃緒申鐃�text鐃緒申鐃緒申regclass鐃舜の逸申鐃緒申的鐃緒申鐃緒申鐃緒申鐃術器申鐃夙わ申鐃銃醐申鐃淳緒申鐃緒申鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申里泙泙離鐃銃ワ申鐃淑醐申鐃緒申鐃夙わ申鐃銃ワ申鐃緒申鐃緒申鐃藷ス関随申鐃塾逸申鐃緒申鐃薯記述わ申鐃緒申鐃緒申蓮鐃�regclass鐃叔￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申砲覆鐃殉わ申鐃緒申鐃緒申鐃緒申鐃獣縁申鐃�OID鐃淑ので￥申鐃緒申鐃縮常申鐃緒申佞鐃緒申鐃緒申討唸圓鐃曙た鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉の再鰹申蠖駈申鐃夙わ申鐃祝件申鐃緒申蕕削申鐃緒申能鐃緒申鐃緒申鐃所さ鐃曙た鐃緒申鐃緒申鐃緒申鐃藷スわ申鐃緒申鐃緒申僂鐃緒申泙鐃緒申鐃緒申鐃緒申鐃�"鐃緒申鐃渋�鐃緒申"鐃緒申動鐃緒申蓮鐃緒申名鐃緒申鐃塾デフワ申鐃緒申箸肇咼紂種申鐃緒申箸鐃緒申襯件申鐃緒申鐃緒申鵐垢砲箸辰鐃縮ワ申呂鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉には実行誌申鐃祝ワ申鐃緒申鐃緒申鐃藷ス誌申鐃夙わ申鐃緒申茲居申鐃緒申茲�鐃緒申"動的束鐃緒申"鐃緒申望鐃殉わ申泙鐃緒申鐃銃暗�束鐃緒申鐃緒申動鐃緒申鐃緒申鐃緒申鐃祝は￥申鐃緒申鐃緒申鐃�regclass鐃叔はなわ申text鐃緒申鐃緒申箸鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申存鐃緒申鐃緒申鐃殉わ申鐃緒申
nextval('foo'::text) foo is looked up at runtime動的束鐃緒申鐃緒申PostgreSQL鐃塾ワ申蝓種申鐃�8.1鐃緒申鐃緒申鐃叔ワ申鐃楯￥申鐃夙わ申鐃曙た動鐃緒申任鐃緒申辰鐃緒申里如鐃緒申鐃緒申鐃塾ワ申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃塾ワ申鐃殉ワ申謄鐃緒申鐃緒申鐃緒申鐃緒申櫃鐃緒申鐃緒申鐃緒申鐃順こ鐃塾よう鐃祝わ申鐃緒申必鐃竣わ申鐃緒申鐃暑か鐃盾し鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鵝▲鐃緒申鐃緒申鐃緒申鵐拘愎鐃緒申琉鐃緒申鐃緒申鐃緒申鐃緒申鐃夙とわ申法鐃宿常申鐃緒申鐃緒申任鐃緒申襪鰹申箸鐃緒申能鐃叔わ申鐃緒申鐃盾し鐃銃ワ申鐃緒申鐃夙種申鐃塾常申鐃熟逸申鐃緒申的鐃緒申鐃緒申鐃緒申鐃術器申鐃緒申鐃渋行誌申鐃緒申鐃緒申鐃緒申鐃術わ申鐃緒申鐃殉わ申鐃緒申
鐃緒申鐃術でわ申鐃暑シ鐃緒申鐃緒申鐃藷ス関随申鐃祝は以駕申鐃塾わ申里鐃緒申鐃緒申鐃殉わ申鐃緒申
nextval
鐃緒申鐃緒申鐃緒申鐃藷スワ申鐃瞬ワ申鐃緒申鐃緒申鐃夙をその種申鐃緒申鐃粛に進め、鐃緒申鐃緒申鐃粛わ申鐃瞬わ申鐃殉わ申鐃緒申鐃緒申鐃緒申麓鐃銃暗�鐃祝緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃淑ｏ申鐃緒申離鐃緒申奪鐃緒申鐃緒申同鐃緒申鐃緒申nextval鐃緒申孫圓鐃緒申鐃緒申箸鐃緒申討癲�鐃緒申鐃曙ぞ鐃緒申離鐃緒申奪鐃緒申鐃緒申聾鐃緒申未離鐃緒申鐃緒申鐃緒申鐃緒申佑鐃瞬違い鐃淑わ申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申
鐃叔フワ申鐃緒申箸離僖鐃潤ー鐃緒申鐃祝わ申辰謄鐃緒申鐃緒申鐃緒申鵐好鐃緒申屮鐃緒申鐃緒申鐃緒申箸鐃緒申鐃緒申鐃緒申鐃緒申鐃銃わ申鐃緒申覆蕁�鐃緒申鐃緒申続鐃緒申nextval鐃銃び出わ申鐃熟ｏ申鐃緒申鐃緒申呂泙鐃熟�続的鐃緒申鐃粛わ申鐃瞬わ申鐃殉わ申鐃緒申鐃緒申鐃緒申他鐃緒申動鐃緒申鐃�CREATE SEQUENCE鐃緒申鐃殉ワ申匹鐃緒申鐃緒申未淵僖鐃潤ー鐃緒申鐃緒申鐃緒申僂鐃緒申討鐃緒申鐃緒申襪鰹申箸鐃緒申鐃叔緒申任鐃緒申鐃緒申鐃緒申椶鐃緒申鐃緒申魯鐃緒申泪鐃宿のワ申侫鐃緒申鐃藷スワ申鐃緒申鐃宿を参照わ申鐃緒申鐃緒申鐃緒申鐃緒申
鐃緒申鐃竣刻申鐃緒申: 同鐃緒申離鐃緒申鐃緒申鐃緒申鵐垢鐃緒申鐃緒申鐃粛わ申鐃緒申鐃緒申鐃緒申鐃銃縁申鐃緒申孫團肇鐃藷ザワ申鐃緒申鐃緒申鐃銃縁申里離屮鐃緒申奪鐃緒申鐃緒申瓢澆鐃緒申襪随申瓠�
nextval鐃初算鐃熟決し鐃銃ワ申鐃緒申鐃緒申丱奪鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃夙醐申鐃緒申鐃緒申鐃夙は￥申鐃緒申鐃夙わ申nextval鐃緒申孫圓鐃緒申鐃緒申肇鐃藷ザワ申鐃緒申鐃緒申鵑�醐申縫鐃緒申棔鐃緒申箸鐃緒申鐃緒申箸鐃緒申討癲�鐃粛わ申鐃緒申鐃駿種申鐃出わ申鐃曙た鐃初そ鐃緒申六鐃緒申僂鐃緒申譴随申鐃塾と考わ申鐃殉わ申鐃緒申 鐃縦まり、鐃緒申鐃旬￥申鐃夙わ申鐃曙た鐃夙ワ申鵐競鐃緒申鐃緒申鐃緒申蓮鐃緒申鐃緒申鐃緒申鐃銃わ申譴随申佑離鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申未鐃緒申鐃術わ申"鐃緒申損"鐃緒申弔鐃緒申鐃叔緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申
currval
鐃緒申鐃淳のワ申鐃獣ワ申鐃緒申鐃祝わ申鐃緒申鐃銃￥申鐃緒申鐃塾ワ申鐃緒申鐃緒申鐃藷スわ申鐃緒申nextval鐃祝わ申辰銅鐃緒申鐃緒申鐃緒申譴芯常申鐃緒申鐃粛わ申鐃瞬わ申鐃殉わ申鐃淑ワ申鐃獣ワ申鐃緒申鐃緒申鐃叔わ申鐃塾ワ申鐃緒申鐃緒申鐃藷スわ申鐃出わ申nextval鐃緒申鐃銃ばわ申討鐃緒申覆鐃緒申鐃緒申砲蓮鐃緒申鐃緒申蕁種申鐃緒申鐃署さわ申泙鐃緒申法鐃緒申鐃緒申鐃熟ワ申鐃緒申鐃緒申鐃緒申離鐃緒申奪鐃緒申鐃緒申鐃粛わ申鐃瞬わ申鐃緒申鐃夙わ申鐃初、鐃緒申鐃淳のワ申鐃獣ワ申鐃緒申鵑�実行わ申鐃銃わ申鐃緒申鐃縮のワ申鐃獣ワ申鐃緒申鐃�nextval鐃緒申孫圓鐃緒申討發件申覆鐃緒申討癲⇒緒申曚飽鐃緒申覆鐃緒申鐃緒申鐃緒申鐃盾た鐃初し鐃殉わ申鐃緒申
lastval
鐃緒申鐃淳のワ申鐃獣ワ申鐃緒申鐃緒申nextval鐃緒申鐃潤さ鐃緒申鐃叔随申鐃緒申鐃粛わ申鐃瞬わ申鐃殉わ申鐃緒申鐃緒申鐃塾関随申鐃熟￥申鐃緒申鐃淳のワ申鐃獣ワ申鐃緒申鐃緒申鐃緒申鐃�nextval鐃祝わ申辰道鐃緒申僂鐃緒申鐃緒申埜鐃塾ワ申鐃緒申鐃緒申鐃藷スわ申鐃粛わ申侫鐃緒申奪鐃緒申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃銃のワ申鐃緒申鐃緒申鐃緒申名鐃緒申鐃暑こ鐃夙わ申鐃緒申鐃緒申董鐃�currval鐃緒申同鐃緒申鐃叔わ申鐃緒申鐃緒申鐃淳のワ申鐃獣ワ申鐃緒申鐃緒申nextval鐃緒申未鐃緒申鐃銃ばわ申討鐃緒申覆鐃緒申鐃出ワ申鐃初ー鐃祝なわ申泙鐃緒申鐃�
setval
鐃緒申鐃緒申鐃緒申鐃藷スワ申鐃瞬ワ申鐃緒申鐃緒申鐃夙の計随申鐃粛わ申螢誌申奪箸鐃緒申泙鐃緒申鐃緒申鐃緒申弔離僖鐃潤ー鐃緒申鐃緒申鐃粛�鐃緒申鐃緒申鐃緒申鐃緒申任蓮鐃緒申鐃緒申鐃緒申鐃緒申鵐垢鐃�last_value鐃春ワ申鐃緒申鐃緒申匹鐃緒申鐃所さ鐃曙た鐃粛わ申鐃緒申鐃所し鐃緒申is_called鐃春ワ申鐃緒申鐃緒申匹鐃�true鐃淑随申鐃祝わ申鐃緒申鐃所し鐃殉わ申鐃緒申鐃緒申鐃塾逸申味鐃熟￥申鐃緒申鐃緒申nextval鐃緒申鐃粛わ申鐃瞬わ申鐃緒申鐃祝ワ申鐃緒申鐃緒申鐃藷スわ申覆鐃緒申箸鐃緒申鐃緒申鐃緒申箸任鐃緒申鐃�currval鐃緒申鐃緒申陲気譴随申佑鐃緒申鐃所さ鐃曙た鐃粛わ申鐃緒申鐃所さ鐃緒申泙鐃緒申鐃緒申鐃緒申僖鐃潤ー鐃緒申鐃緒申鐃緒申鐃塾常申隋�is_called鐃緒申true鐃淑随申鐃祝もし鐃緒申鐃緒申false鐃淑居申鐃祝わ申鐃緒申鐃所す鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申true鐃淑随申鐃祝はｏ申鐃術ワ申瓠種申鐃緒申鐃緒申鐃緒申鐃銃縁申鐃緒申鐃緒申未鐃緒申鐃緒申鐃殉わ申鐃緒申false鐃淑居申鐃祝わ申鐃緒申鐃所さ鐃曙た鐃緒申隋�鐃緒申鐃緒申nextval鐃緒申鐃緒申鐃所さ鐃曙た鐃緒申鐃塾わ申鐃粛わ申鐃瞬わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃藷スの進行は逸申鐃緒申続鐃緒申nextval鐃緒申鐃緒申呂泙鐃殉わ申鐃緒申鐃緒申鐃緒申砲鐃緒申両鐃緒申覆鐃緒申鐃緒申8.3鐃緒申鐃緒申鐃緒申動鐃庶か鐃緒申鐃緒申儿鐃緒申法鐃�currval鐃緒申鐃緒申陲気譴随申佑鐃緒申儿鐃緒申鐃緒申鐃殉わ申鐃緒申鐃純え鐃出￥申鐃緒申鐃緒申鐃緒申任鐃緒申鐃�
SELECT setval('foo', 42); Next nextval will return 43
SELECT setval('foo', 42, true); Same as above
SELECT setval('foo', 42, false); Next nextval will return 42
setval鐃祝わ申辰鐃緒申屬鐃緒申鐃緒申鐃縮わ申単鐃祝わ申鐃緒申鐃緒申2鐃緒申鐃旬の逸申鐃緒申鐃緒申鐃粛でわ申鐃緒申
鐃緒申鐃竣刻申鐃緒申: 鐃緒申鐃緒申鐃緒申鐃藷スわ申鐃緒申肇鐃藷ザワ申鐃緒申鐃緒申淵鐃祝逸申鐃緒申鐃暑た鐃潤、
setval鐃祝わ申鐃緒申儿鐃緒申蓮鐃緒申鐃緒申離肇鐃藷ザワ申鐃緒申鐃緒申鵑�ワ申鐃緒申鐃緒申丱奪鐃緒申鐃緒申譴随申箸鐃緒申討鐃� 鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申
| 鐃緒申鐃塾ペ￥申鐃緒申 | 鐃循￥申鐃緒申 | 鐃緒申鐃塾ペ￥申鐃緒申 |
| JSON鐃舜随申鐃夙演算鐃緒申 | 鐃緒申鐃緒申鐃緒申 | 鐃緒申鐚� |