Is your feature request related to a problem or challenge?
Per #21240 (comment) , if the same subquery (identical SQL text) appears multiple times in a query, it will be planned and evaluated multiple times. In principle it should be fine to evaluate it only once, provided the subquery doesn't contain any volatile functions (e.g., random()).
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response
Is your feature request related to a problem or challenge?
Per #21240 (comment) , if the same subquery (identical SQL text) appears multiple times in a query, it will be planned and evaluated multiple times. In principle it should be fine to evaluate it only once, provided the subquery doesn't contain any volatile functions (e.g.,
random()).Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response