Nullif postgresql

SELECT
	NULLIF (1, 1); -- return NULL

SELECT
	NULLIF (1, 0); -- return 1

SELECT
	NULLIF ('A', 'B'); -- return A
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote337 views1 answer
Sql anywhere create procedure
SQL
25 votes338 views5 answers
Uninstall mysql ubuntu
SQL
0 vote371 views1 answer
Sql sum show 0 result
SQL
1 vote351 views1 answer
Oracle schema size
SQL
0 vote361 views1 answer
Plsql find location of procedure
SQL
1 vote349 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote352 views1 answer
Get date ISO in psql
SQL
4 votes330 views3 answers
Mysql varchar length
SQL
1 vote337 views1 answer
Oracle split string
SQL
0 vote325 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL