The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide by The PostgreSQL Global Development Group Paperback (6"x9"), 478 pages ISBN 9781906966065 RRP £14.95 ($19.95) Sales of this book support the PostgreSQL project! Get a printed copy>>>

PostgreSQL 9.0 Reference Manual Volume 2 Buy the book here! >>> only $19.95

9.6.2 Conditionals

IF and CASE statements let you execute alternative commands based on certain conditions. PL/pgSQL has three forms of IF:

• IF ... THEN
• IF ... THEN ... ELSE
• IF ... THEN ... ELSIF ... THEN ... ELSE

and two forms of CASE:

• CASE ... WHEN ... THEN ... ELSE ... END CASE
• CASE WHEN ... THEN ... ELSE ... END CASE