Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from taxi_order t
- where
- status = 'waiting' and
- exists (
- select from jsonb_array_elements(t.log::jsonb) q
- where q->>'status' = 'waiting' and (q->>'created_at')::timestamptz <= now() - '40 minutes'::interval
- )
- order by created_at desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement