En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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?

Sujets
Analytique
Balises
Amazon Redshift
Langue
English
Kit - CostCenter
demandé il y a 8 mois155 vues
1 réponse
1
Réponse acceptée

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
répondu il y a 8 mois
  • Kit - CostCenter
    il y a 8 mois

    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.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents