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