Advertisement
Guest User

Untitled

a guest
Aug 19th, 2019
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. CREATE FUNCTION replace_value(data JSON, key text, value anyelement)
  2. RETURNS JSON AS $$
  3. import json
  4. d = json.loads(data)
  5. d[key] = value
  6. return json.dumps(d)
  7. $$ LANGUAGE plpython3u;
  8.  
  9. ERROR: PL/Python functions cannot accept type anyelement
  10.  
  11. CREATE FUNCTION replace_value(data JSON, key text, value text)...
  12. CREATE FUNCTION replace_value(data JSON, key text, value float)...
  13. CREATE FUNCTION replace_value(data JSON, key text, value bigint)...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement