NullIf Conditional Expression: PostgreSQL PSQL PSQL | Screencasts | Teachmedatabase

Описание: NullIf Conditional Expressions: Postgresql/PSQL #psql #database #programming #nullif

teachmedatabase.com is focused on helping you become a pro when it comes to databases and become a strongly skilled backend/full-stack engineer. Signup for the newsletter and exclusive screencasts access: https://www.teachmedatabase.com/

This screencast will take a gander at a useful conditional expression provided by PostgreSQL/PSQL called NullIf. This is another side of Coalesce. Coalesce Detail:    • Coalesce Conditional Expressions: Postgres...  

It takes two arguments. One constraint is that both of them should be of the same type. It is mainly useful for returning a null value in case both arguments are equal. It chooses the first argument from the list you provided if they are not equal or one or both is null.

Thanks for watching, if you like what you saw, give the video a like, and don't forget to subscribe! It inspires me to keep going.

📌 Github PostgreSQL Mirror: https://github.com/postgres/postgres/...
📌 Doxygen PostgreSQL Documentation: https://doxygen.postgresql.org/struct...
📌 PostgreSQL Documentation on Conditional Expressions: https://www.postgresql.org/docs/curre...
🔰 Datagrip IDE: https://www.jetbrains.com/datagrip/