"Delaney, Ed" <Ed.Delaney@ellucian.com> writes:
> I could not find a reference to this change in the release notes, but since it is a breaking change, perhaps it
shouldbe noted?
The 2021-11-11 release notes all say
* Don't discard a cast to the same type with unspecified type modifier (Tom Lane)
For example, if column f1 is of type numeric(18,3), the parser used to
simply discard a cast like f1::numeric, on the grounds that it would
have no run-time effect. That's true, but the exposed type of the
expression should still be considered to be plain numeric, not
numeric(18,3). This is important for correctly resolving the type of
larger constructs, such as recursive UNIONs.
regards, tom lane
