CODEWITHSUNDEEP
sqlpostgresql
Débora
Débora

Reputation: 5952

postgres functions : difference between CASE WHEN and IF ELSE

Can any one let me know what the differences are between WHEN CASE .. and IF/ELSE when writing in Postgres functions.

Upvotes: 6

Views: 5444

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294227

The problem is which CASE do you mean?

One CASE is an expression. It can appear inside expressions, like A + CASE ... + B. Along with COALESCE, NULLIF, GREATEST and LEAST it makes the group of conditional expressions.

The other CASE, along with IF, is a control structure (a conditional). It can appear in the SQL control flow to chose what blocks/statements are executed, based on a condition.

Upvotes: 4

Related Questions