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: 200205240955.04439.tansley@law.du.edu (view raw or flat)
Thread:
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' 
END

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' 
END

and this

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

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

Thanks

Tom Ansley

Responses

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-2014 The PostgreSQL Global Development Group