Search Postgresql Archives

Re: IF function?

To: Harpreet Dhaliwal <harpreet.dhaliwal01@xxxxxxxxx>
Subject: Re: IF function?
From: "Eddy D. Sanchez" <eddy.sanchez@xxxxxxxxx>
Date: Tue, 1 May 2007 23:37:50 -0400
Cc: novnov <novnovice@xxxxxxxxx>, PostgreSQL <pgsql-general@xxxxxxxxxxxxxx>
Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:in-reply-to:references:mime-version:content-type:message-id:cc:content-transfer-encoding:from:subject:date:to:x-mailer; b=Q28D1B+bOdTBDr+Cd4W6Q4cJHywUER+Qk1QYrNTQKMAaXZrZKIH6E093H9NUQRnQOb2ifu9PzHRr08X5nUs4leFH2HlzBDHXsUjlFuGTNsgSDbJXq+fhE5fzoT/yAk/9NoEivb/ekVcdOOBVNJog7qUup8P5aR/u5Y/jxjkmZ8o=
In-reply-to: <d86a77ef0704302259qb8ea1dcv985e02552e180d1@xxxxxxxxxxxxxx>
References: <10264910.post@xxxxxxxxxxxxxxx> <d86a77ef0704302259qb8ea1dcv985e02552e180d1@xxxxxxxxxxxxxx>

You must use
CASE var=val2 THEN [true statement] ELSE [false statement] END

References:
- IF function?
  - From: novnov
- Re: IF function?
  - From: Harpreet Dhaliwal