Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. select * from taxi_order t
  2. where
  3. status = 'waiting' and
  4. exists (
  5. select from jsonb_array_elements(t.log::jsonb) q
  6. where q->>'status' = 'waiting' and (q->>'created_at')::timestamptz <= now() - '40 minutes'::interval
  7. )
  8. order by created_at desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement