AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

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?

주제
분석
태그
아마존 Redshift
언어
English
Kit - CostCenter
질문됨 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
MilindOke
답변함 8달 전
  • Kit - CostCenter
    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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠