Create a new column based on values of other columns in postgres

Question

What i have

customer_id
   1
   2 
   2
   1
   3

What i want (for all customer id's with 1 ,i want to flag as valid ,rest of the customer id's as invalid in the new column "warining_customer_id"

customer_id    warining_customer_id
   1             Valid
   2             Invalid
   2             Invalid
   1             Valid
   3             Invalid

Hint: CASE expression.

Gordon Linoff
– Gordon Linoff

2018-05-22 22:22:34 +00:00
Commented May 22, 2018 at 22:22 — Gordon Linoff
– Gordon Linoff, Commented May 22, 2018 at 22:22
Use update table1 set warining_customer_id = ...

The Impaler
– The Impaler

2018-05-23 03:04:54 +00:00
Commented May 23, 2018 at 3:04 — The Impaler
– The Impaler, Commented May 23, 2018 at 3:04

Mihawk · Accepted Answer · 2018-05-23 05:47:28Z

1

Here an example

SELECT   customer.customer_id AS customer_id,
         CASE WHEN customer.customer_id = 1 THEN 'Valid' ELSE 'Invalid' END
             AS warning_customer_id
  FROM   (SELECT   1 AS customer_id FROM DUAL
          UNION ALL
          SELECT   2 AS customer_id FROM DUAL) customer

answered May 23, 2018 at 5:47

Mihawk

8353 gold badges14 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Create a new column based on values of other columns in postgres

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