What specifically is Amazon Redshift patch 178 changing for DECODE?

Question

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?

Accepted Answer

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

What specifically is Amazon Redshift patch 178 changing for DECODE?

Relevanter Inhalt