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 vote334 views1 answer
Get primary key of table
SQL
22 votes398 views4 answers
Mysql format date
SQL
1 vote344 views2 answers
Mysql add column tinyint default 0
SQL
1 vote332 views1 answer
Altrer name column postgres
SQL
3 votes288 views1 answer
Index using in query plsql
SQL
0 vote317 views1 answer
Postgresql create query
SQL
5 votes336 views1 answer
Mysql add user with all privileges
SQL
0 vote332 views1 answer
Postgre query date
SQL
15 votes320 views4 answers
Export mysql db using command line
SQL
0 vote328 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL