PostgreSQL select columns based on case statement

Question

I have the following sql query:

SELECT id, first_name, last_name FROM users;

Now I want to add a case statement with the following clauses:

 1. If 1+1 == 2 then show only id column
 2. If 1+2 == 2 then show only first_name column
 3. If 1+3 == 3 then show only last_name column

This is only stupid example but should describe what I'm looking for. Is there a way to do this in PostgreSQL?

postgresql.org has documentations on postgresql. Take a look at the documentations for conditional expressions: postgresql.org/docs/8.4/static/functions-conditional.html — Jonast92
– Jonast92, Commented Aug 30, 2017 at 11:48

Lukasz Szozda · Accepted Answer · 2017-08-30 11:41:42Z

3

You could use CASE:

SELECT CASE WHEN cond1 THEN id:TEXT
            WHEN cond2 THEN first_name::TEXT
            WHEN cond3 THEN last_name::TEXT
            ELSE 'some_default_value'
       END
FROM your_table;

answered Aug 30, 2017 at 11:41

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL select columns based on case statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related