how to use a column value in postgresql

Question

order_item_id   order_status   weight
158871745        "delivered"       0.3
158032756        "delivered"       0.3
158871745        "return"          0.5

i want to find the difference between weight of same order_item_id have different

order_status

i want output like

 order_item_id   order_status  weight   error 
    158871745     "return"      0.5      0.2

would there ever be more than two instances of weight per order_item_id? — Matt
– Matt, Commented Mar 24, 2015 at 11:17
Please edit your question and show the results that you want. — Gordon Linoff
– Gordon Linoff, Commented Mar 24, 2015 at 11:31

Dani · Accepted Answer · 2015-03-24 11:18:40Z

1

select t1.weight-t2.weight from table as 't1' join table as 't2' on t1.order_item_id=t2.order_item_id where t1.order_status!=t2.order_status;

where table is the actual name of the table.

answered Mar 24, 2015 at 11:18

Dani

1814 bronze badges

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

Comments

Gordon Linoff · Accepted Answer · 2015-03-24 11:33:04Z

0

One method uses window functions:

select t.*,
       (case when min(order_status) over (partition by order_item_id) <>
                  max(order_status) over (partition by order_item_id)
             then max(weight) over (partition by order_item_id) - 
                  min(weight) over (partition by order_item_id)
        end) as weightdiff
from table t;

answered Mar 24, 2015 at 11:33

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

how to use a column value in postgresql

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