_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › PostgreSQLReference

Contents

1 覦一伎 覯 覿願鍵


1 覦一伎 覯 覿願鍵 #

--ver 9.4
--覦覯1
;with foo
as
(
	select 1 id, array['a','b','c'] val
	union all
	select 2 id, array['d','e','f'] val
)
select 
	a.id
,	a.val[b.seq] val
,	b.seq
from foo a
	cross join lateral generate_subscripts(val, 1) b(seq);

--覦覯2
;with foo
as
(
	select 1 id, array['a','b','c'] val
	union all
	select 2 id, array['d','e','f'] val
)
select
	a.id
,	b.val
,	b.seq
from foo a
	cross join lateral unnest(val) with ordinality b(val, seq);
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

譴 蟆 讌蠍 覦朱 螳螻 り 覩遂 蟆企. (一企 觜れ洲)