Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. UPDATE designs
  2. SET prices = '{ "at": 507, "ch": 751, "de": 447 }'
  3. WHERE prices IS NULL;
  4.  
  5. SELECT * FROM designs
  6. WHERE prices = '{ "at": 507, "ch": 751, "de": 447 }';
  7.  
  8. ERROR: operator does not exist: json = unknown
  9.  
  10. SELECT * FROM designs WHERE prices::TEXT = '{ "x": 3 }';
  11.  
  12. SELECT * FROM designs WHERE prices::TEXT = '{ "x": 3 }'::JSON::TEXT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement