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

2 votes162 views5 answers
Alter table primary key postgresql
SQL
1 vote175 views1 answer
Is sql fast
SQL
0 vote139 views1 answer
FindAllBy
SQL
-1 vote187 views1 answer
Concat two columns in sql server
SQL
5 votes197 views4 answers
SQL Order of execution
SQL
13 votes177 views2 answers
Get date from now() mysql
SQL
1 vote179 views1 answer
Pl sql insert into table
SQL
0 vote179 views1 answer
Oracle search in date columns
SQL
0 vote199 views4 answers
Restart MySQL
SQL
0 vote186 views1 answer
How to install postgresql on wsl
SQL