Skip site navigation (1) Skip section navigation (2)

Using CASE with a boolean value

From: Tom Ansley <tansley(at)law(dot)du(dot)edu>
To: Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Using CASE with a boolean value
Date: 2002-05-24 15:55:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi all,

I'm trying to use a case statement with a boolean value.  i.e.  if the value = 
false then output 'NO', if value = true then output 'YES'.  This is what I 
came up with

CASE booking.quiz 
	WHEN booking.quiz=false THEN 'No' 
	WHEN booking.quiz=true THEN 'Yes' 
	ELSE 'No' 

But, it isn't working.  Everything compiles and the rows returned are correct 
but it still returns 'true' or 'false' rather than 'YES' or 'NO'.  I've also 
tried this

CASE booking.quiz 
	WHEN booking.quiz='f' THEN 'No' 
	WHEN booking.quiz='t' THEN 'Yes' 
	ELSE 'No' 

and this

CASE booking.quiz 
	WHEN booking.quiz='false' THEN 'No' 
	WHEN booking.quiz='true' THEN 'Yes' 
	ELSE 'No' 

Anybody got any ideas?  Should the value be cast into a string?


Tom Ansley


pgsql-novice by date

Next:From: Joel BurtonDate: 2002-05-24 15:59:37
Subject: Re: Using CASE with a boolean value
Previous:From: Rory Campbell-LangeDate: 2002-05-24 15:12:53
Subject: Re: auto update dates

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group