What is wrong with my Postgres statement?

Question

SELECT first_name, last_name, manager_id
    CASE manager_id
        WHEN manager_id IS null THEN "pip"
        End manager_id
    FROM assgnssql.employees;

I am trying to select list of employees, but i know some employees do not have manager_id, for these employees without manager_id (null) i want the result to display "pip" while for the rest it displays original info.

For one thing, you are using double quotes for a string, when the accepted delimiter is single quotes. — Gordon Linoff
– Gordon Linoff, Commented Oct 6, 2020 at 0:32

Gordon Linoff · Accepted Answer · 2020-10-06 12:34:40Z

1

The code you want is probably:

SELECT first_name, last_name, manager_id
        (CASE WHEN manager_id IS null THEN 'pip' ELSE manager_id
         END) as manager_id
FROM assgnssql.employees;

Or more simply:

SELECT first_name, last_name, manager_id
       COALESCE(manager_id, 'pip') as manager_id
FROM assgnssql.employees;

The two significant issues are:

Your CASE syntax is messed up. Either you use comparisons or you have CASE <value>, but not both.
Strings are delimited by single quotes.

edited Oct 6, 2020 at 12:34

answered Oct 6, 2020 at 0:33

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

1 Comment

Alinafe Over a year ago

Thanks everybody for all the feedback and pointers. I was able to edit @Gordon Linoff answer to do what i wanted.

Collectives™ on Stack Overflow

What is wrong with my Postgres statement?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related