解码等效于Postgres [英] Decode equivalent in postgres

问题描述

没有等效于Oracle的DECODE()'Function In Postgres`.有没有人写过解码为函数?

There is no equivalent to the Oracle's DECODE()'Function InPostgres`. Is there anyone who wrote decode as a Function?

推荐答案

有一个等效项.它称为 CASE 语句.

There is an equivalent. It's called a CASE statement.

CASE有两种形式:

There are two forms of CASE:

简单案例:

CASE search-expression
    WHEN expression [, expression [ ... ]] THEN
      statements
  [ WHEN expression [, expression [ ... ]] THEN
      statements
    ... ]
  [ ELSE
      statements ]
END CASE;

搜索到的案例:

CASE
    WHEN boolean-expression THEN
      statements
  [ WHEN boolean-expression THEN
      statements
    ... ]
  [ ELSE
      statements ]
END CASE;

CASE语句更易于阅读；我更喜欢这些，而不是Oracle中的decode().

CASE statements are easier to read; I prefer these over decode() in Oracle.

这篇关于解码等效于Postgres的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！