Commit2373fe7

committed

doc: add examples for array_length() and jsonb_array_length()

The examples show the output of array_length() and jsonb_array_length()for empty arrays.Discussion:https://postgr.es/m/CAKFQuwaoBmRuWdMLzLHDCFDJDX3wvfQ7egAF0bpik_BFgG1KWg@mail.gmail.comAuthor: David G. JohnstonBackpatch-through: 13

1 parentaa31b29 commit2373fe7Copy full SHA for 2373fe7

File tree

+13

-0

lines changed

+13

-0

lines changed

Lines changed: 13 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -15867,6 +15867,10 @@ table2-mapping`
`15867`	`15867`	`<para>`
`15868`	`15868`	`<literal>json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]')</literal>`
`15869`	`15869`	`<returnvalue>5</returnvalue>`
	`15870`	`+ </para>`
	`15871`	`+ <para>`
	`15872`	`+ <literal>jsonb_array_length('[]')</literal>`
	`15873`	`+ <returnvalue>0</returnvalue>`
`15870`	`15874`	`</para></entry>`
`15871`	`15875`	`</row>`
`15872`	`15876`
`@@ -19238,10 +19242,19 @@ SELECT NULLIF(value, '(none)') ...`
`19238`	`19242`	`</para>`
`19239`	`19243`	`<para>`
`19240`	`19244`	`Returns the length of the requested array dimension.`
	`19245`	`+ (Produces NULL instead of 0 for empty or missing array dimensions.)`
`19241`	`19246`	`</para>`
`19242`	`19247`	`<para>`
`19243`	`19248`	`<literal>array_length(array[1,2,3], 1)</literal>`
`19244`	`19249`	`<returnvalue>3</returnvalue>`
	`19250`	`+ </para>`
	`19251`	`+ <para>`
	`19252`	`+ <literal>array_length(array[]::int[], 1)</literal>`
	`19253`	`+ <returnvalue>NULL</returnvalue>`
	`19254`	`+ </para>`
	`19255`	`+ <para>`
	`19256`	`+ <literal>array_length(array['text'], 2)</literal>`
	`19257`	`+ <returnvalue>NULL</returnvalue>`
`19245`	`19258`	`</para></entry>`
`19246`	`19259`	`</row>`
`19247`	`19260`

Comments

(0)