Commit5594d14

committed

Add composite-type attributes to information_schema.element_types view

1 parentc533c14 commit5594d14Copy full SHA for 5594d14

File tree

+10

-7

lines changed

+10

-7

lines changed

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -2147,7 +2147,7 @@`
`2147`	`2147`
`2148`	`2148`	`<para>`
`2149`	`2149`	`The view <literal>element_types</literal> contains the data type`
`2150`		`- descriptors of the elements of arrays. When a table column,`
	`2150`	`+ descriptors of the elements of arrays. When a table column, composite-type attribute,`
`2151`	`2151`	`domain, function parameter, or function return value is defined to`
`2152`	`2152`	`be of an array type, the respective information schema view only`
`2153`	`2153`	`contains <literal>ARRAY</literal> in the column`
`@@ -2212,9 +2212,11 @@ ORDER BY c.ordinal_position;`
`2212`	`2212`	`<entry>`
`2213`	`2213`	`The type of the object that uses the array being described: one`
`2214`	`2214`	`of <literal>TABLE</literal> (the array is used by a column of`
`2215`		`- that table), <literal>DOMAIN</literal> (the array is used by`
`2216`		`- that domain), <literal>ROUTINE</literal> (the array is used by`
`2217`		`- a parameter or the return data type of that function).`
	`2215`	`+ that table), <literal>USER-DEFINED TYPE</literal> (the array is`
	`2216`	`+ used by an attribute of that composite type),`
	`2217`	`+ <literal>DOMAIN</literal> (the array is used by that domain),`
	`2218`	`+ <literal>ROUTINE</literal> (the array is used by a parameter or`
	`2219`	`+ the return data type of that function).`
`2218`	`2220`	`</entry>`
`2219`	`2221`	`</row>`
`2220`	`2222`

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -2467,12 +2467,13 @@ CREATE VIEW element_types AS`
`2467`	`2467`
`2468`	`2468`	`FROM pg_namespace n, pg_type at, pg_namespace nbt, pg_type bt,`
`2469`	`2469`	`(`
`2470`		`-/* columns*/`
	`2470`	`+/* columns, attributes*/`
`2471`	`2471`	`SELECTc.relnamespace, CAST(c.relnameAS sql_identifier),`
`2472`		`-'TABLE'::text,a.attnum,a.atttypid`
	`2472`	`+ CASE WHENc.relkind='c' THEN'USER-DEFINED TYPE'::text ELSE'TABLE'::text END,`
	`2473`	`+a.attnum,a.atttypid`
`2473`	`2474`	`FROM pg_class c, pg_attribute a`
`2474`	`2475`	`WHEREc.oid=a.attrelid`
`2475`		`-ANDc.relkindIN ('r','v','f')`
	`2476`	`+ANDc.relkindIN ('r','v','f','c')`
`2476`	`2477`	`AND attnum>0AND NOT attisdropped`
`2477`	`2478`
`2478`	`2479`	`UNION ALL`

Comments

(0)