What specifically is Amazon Redshift patch 178 changing for DECODE?

0

In the cluster patch notes for path 178 https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html:

The DECODE function replaces a specific value with either another specific value or a default value, depending on the result of an equality condition. DECODE now requires the following three parameters:

  • expression
  • search
  • result

The DECODE function already exists and was documented, what exactly is it that's changing vs the previous version?

已提问 8 个月前155 查看次数
1 回答
1
已接受的回答

The only change I see is replacing the word "expression" with "function".

Refer the Internet Archive changes captured between February 2023 Vs. the latest page

https://web.archive.org/web/diff/20230202123513/20231016084824/https://docs.aws.amazon.com/redshift/latest/dg/r_DECODE_expression.html

profile pictureAWS
已回答 8 个月前
  • I guess they made it into a real function rather than SQL syntax, it isn't registered as one on previous versions according to system tables.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容