postgres nullif

COALESCE · 9.17.3. NULLIF · 9.17.4. GREATEST and LEAST. This section describes the SQL -compliant conditio...

postgres nullif

COALESCE · 9.17.3. NULLIF · 9.17.4. GREATEST and LEAST. This section describes the SQL -compliant conditional expressions available in PostgreSQL. ,The NULLIF function returns NULL if and only if value1 and value2 are equal. Otherwise it returns value1. This can be used to perform the inverse operation of ...

相關軟體 PostgreSQL (64-bit) 資訊

PostgreSQL (64-bit)
PostgreSQL 64 位是一個功能強大的開源對象關係數據庫系統。它擁有超過 15 年的積極開發和經過驗證的架構,在可靠性,數據完整性和正確性方面贏得了良好聲譽。它運行在所有主要的操作系統上,包括 Linux,UNIX(AIX,BSD,HP-UX,SGI IRIX,Mac OS X,Solaris,Tru64)和 Windows。  PostgreSQL 64 位是一個功能強大的對象... PostgreSQL (64-bit) 軟體介紹

postgres nullif 相關參考資料
Documentation: 10: 9.17. Conditional Expressions - PostgreSQL

COALESCE · 9.17.3. NULLIF · 9.17.4. GREATEST and LEAST. This section describes the SQL -compliant conditional expressions available in PostgreSQL.

https://www.postgresql.org

Documentation: 12: 9.17. Conditional Expressions - PostgreSQL

COALESCE · 9.17.3. NULLIF · 9.17.4. GREATEST and LEAST. This section describes the SQL -compliant conditional expressions available in PostgreSQL.

https://www.postgresql.org

Documentation: 7.1: Conditional Expressions - PostgreSQL

The NULLIF function returns NULL if and only if value1 and value2 are equal. Otherwise it returns value1. This can be used to perform the inverse operation of ...

https://www.postgresql.org

Documentation: 8.4: Conditional Expressions - PostgreSQL

NULLIF. NULLIF (value1, value2). The NULLIF function returns a null value if value1 equals value2; otherwise it returns value1. This can be used to perform the ...

https://www.postgresql.org

Documentation: 9.1: Conditional Expressions - PostgreSQL

NULLIF. NULLIF (value1, value2). The NULLIF function returns a null value if value1 equals value2; otherwise it returns value1. This can be used to perform the ...

https://www.postgresql.org

Documentation: 9.2: Conditional Expressions - PostgreSQL

NULLIF. NULLIF (value1, value2). The NULLIF function returns a null value if value1 equals value2; otherwise it returns value1. This can be used to perform the ...

https://www.postgresql.org

Documentation: 9.5: Conditional Expressions - PostgreSQL

NULLIF. NULLIF (value1, value2). The NULLIF function returns a null value if value1 equals value2; otherwise it returns value1. This can be used to perform the ...

https://www.postgresql.org

PostgreSQL NULLIF function - PostgreSQL Tutorial

This tutorial shows you how to apply the PostgreSQL NULLIF function to substitute the null values for displaying data and preventing division by zero error.

http://www.postgresqltutorial.

條件資料表達式

條件資料表達式. 本節描述在PostgreSQL 裡可以用的SQL兼容的條件資料表達式。 ... 當且僅當 value1 和 value2 相等時,NULLIF 才返回NULL。 否則它返回value1。

http://twpug.net