postgresql - how to manipulate the query results?

Question

Say I have this query:

SELECT name::text, id::int, pass:bool FROM mytable;

which gives me this view table:

name   id    pass
------------------
A      123    t
B      234    t
C      345    f

How do I tell postgres to give me this instead

name   id    pass
--------------------
A      123   passed
B      234   passed
C      345   failed

I tried the CASE WHEN condition THEN result; but that just gives me another column 'case'.
(if there's no easy way for postgres, is there any in psycopg2 ? because I mainly use it to get the data I want)

Thanks in advance

That sort of formatting really belongs in your application (IMO), a simple dictionary should do the trick in Python or possible a dictionary combined with your localized string handling system if you care about people that don't read English. — mu is too short
– mu is too short, Commented Dec 19, 2011 at 22:38
@A.H oh haha actually no, I just wanted to show you guys the data types — BPm
– BPm, Commented Dec 19, 2011 at 22:45

aleroot · Accepted Answer · 2011-12-19 22:26:42Z

7

SELECT name::text, id::int, 
CASE WHEN pass = true THEN 'passed' ELSE 'failed' END AS pass 
FROM mytable;

answered Dec 19, 2011 at 22:26

aleroot

73k32 gold badges182 silver badges220 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

A.H. · Accepted Answer · 2011-12-19 22:28:57Z

4

You can use this one:

select case pass when true then 'passed' when false then 'failed' else null end pass from...

answered Dec 19, 2011 at 22:28

A.H.

66.8k16 gold badges98 silver badges132 bronze badges

Collectives™ on Stack Overflow

postgresql - how to manipulate the query results?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related