yjhjstz commented on issue #1245: URL: https://github.com/apache/cloudberry/issues/1245#issuecomment-3091292880
## Root Cause This behavior difference is due to **upstream PostgreSQL changes**. PostgreSQL removed postfix operator support in version 14, as discussed in the community thread: https://postgrespro.com/list/thread-id/2506502 **Why the difference:** - **Cloudberry** is based on PostgreSQL 14.4, which no longer supports postfix operators - **Greenplum 7** is based on PostgreSQL 12.12, which still retained this feature The removal was intentional to resolve parser ambiguity issues and simplify grammar handling. Since Cloudberry follows upstream PostgreSQL 14+, this limitation is inherited from the upstream decision. **Migration recommendation:** Replace postfix operators with equivalent function calls (e.g., `x!` → `factorial(x)`) in DDL scripts when migrating from Greenplum to Cloudberry. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
