Guest User

Untitled

a guest
Jan 17th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION JsonParse(inputdata json)
  2. RETURNS void AS $$
  3. DECLARE
  4. BEGIN
  5.  
  6. UPDATE
  7. MyTable
  8. SET
  9. settings_details= inputdata
  10. WHERE
  11. settings_key='my-list';
  12.  
  13. END;
  14. $$
  15. LANGUAGE PLPGSQL;
  16.  
  17. select * from JsonParse('{
  18. "myArray": ["New Text1 'abcd'", "New Text1 'efgh'"]
  19. }');
Add Comment
Please, Sign In to add comment