Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE "Order"
- SET room_number=(SELECT "Room".room_number
- FROM public."Room"
- WHERE "Room".room_number=cast(? AS INT)),
- status_id=(SELECT "Order_status".status_id
- FROM public."Order_status"
- WHERE "Order_status".order_status_en='confirmed'),
- full_cost=coalesce((((SELECT "Order".check_out
- FROM public."Order"
- WHERE "Order".order_id=cast(? AS INT)) -
- (SELECT "Order".check_in
- FROM public."Order"
- WHERE "Order".order_id=cast(? AS INT))) *
- (SELECT "Room".room_price
- FROM public."Room"
- WHERE "Room".room_number=cast(? AS INT))), full_cost)
- WHERE exists(SELECT 1 FROM public."Room" WHERE "Room".room_number=cast(? AS INT))
- AND "Order".order_id=cast(? AS INT) AND "Order".status_id=(SELECT "Order_status".status_id
- FROM public."Order_status"
- WHERE "Order_status".order_status_en='unconfirmed');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement