Commitc246eb5

committed

Make use of LATERAL in information_schema.sequences view.

It said "XXX: The following could be improved if we had LATERAL" ...so let's do that.No catversion bump since either version of the view works fine.

1 parent084a29c commitc246eb5Copy full SHA for c246eb5

File tree

-7

lines changed

-7

lines changed

Lines changed: 6 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -1521,13 +1521,12 @@ CREATE VIEW sequences AS`
`1521`	`1521`	`CAST(64AS cardinal_number)AS numeric_precision,`
`1522`	`1522`	`CAST(2AS cardinal_number)AS numeric_precision_radix,`
`1523`	`1523`	`CAST(0AS cardinal_number)AS numeric_scale,`
`1524`		`--- XXX: The following could be improved if we had LATERAL.`
`1525`		`- CAST((pg_sequence_parameters(c.oid)).start_valueAS character_data)AS start_value,`
`1526`		`- CAST((pg_sequence_parameters(c.oid)).minimum_valueAS character_data)AS minimum_value,`
`1527`		`- CAST((pg_sequence_parameters(c.oid)).maximum_valueAS character_data)AS maximum_value,`
`1528`		`- CAST((pg_sequence_parameters(c.oid)).incrementAS character_data)AS increment,`
`1529`		`- CAST(CASE WHEN (pg_sequence_parameters(c.oid)).cycle_option THEN'YES' ELSE'NO' ENDAS yes_or_no)AS cycle_option`
`1530`		`-FROM pg_namespace nc, pg_class c`
	`1524`	`+ CAST(p.start_valueAS character_data)AS start_value,`
	`1525`	`+ CAST(p.minimum_valueAS character_data)AS minimum_value,`
	`1526`	`+ CAST(p.maximum_valueAS character_data)AS maximum_value,`
	`1527`	`+ CAST(p.incrementAS character_data)AS increment,`
	`1528`	`+ CAST(CASE WHENp.cycle_option THEN'YES' ELSE'NO' ENDAS yes_or_no)AS cycle_option`
	`1529`	`+FROM pg_namespace nc, pg_class c, LATERAL pg_sequence_parameters(c.oid) p`
`1531`	`1530`	`WHEREc.relnamespace=nc.oid`
`1532`	`1531`	`ANDc.relkind='S'`
`1533`	`1532`	`AND (NOT pg_is_other_temp_schema(nc.oid))`

Comments

(0)