Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION JsonParse(inputdata json)
- RETURNS void AS $$
- DECLARE
- BEGIN
- UPDATE
- MyTable
- SET
- settings_details= inputdata
- WHERE
- settings_key='my-list';
- END;
- $$
- LANGUAGE PLPGSQL;
- select * from JsonParse('{
- "myArray": ["New Text1 'abcd'", "New Text1 'efgh'"]
- }');
Add Comment
Please, Sign In to add comment