Inspectopedia
 
2024.3

Postgres: Select from procedure call

Warning
New
Last modified: 03 December 2024

Reports situations when you make SELECT from a function or a DBLINK without an alias with a type (for example, AS t1(s VARCHAR)).

This requirement does not apply to scalar functions.

Example (PostgreSQL):

The AS s (c1 INT) has a typed alias, while AS s (c1) and AS t1 do not. In this case, the second call of produce_a_table() and DBLINK() will be highlighted.