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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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