By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
| criterias |
|---|
| {"{"url":"https://criteria.com", "description":"My Criteria"}","{"url":"https://criteria2.com", "description":"Other Criteria"}"} |
INSERT 0 1
| criterias | criterias_js |
|---|---|
| {"{"url":"https://criteria.com", "description":"My Criteria"}","{"url":"https://criteria2.com", "description":"Other Criteria"}"} | [{"url": "https://criteria.com", "description": "My Criteria"}, {"url": "https://criteria2.com", "description": "Other Criteria"}] |
SELECT 1
CREATE FUNCTION
| criterias | arr2jsb |
|---|---|
| {"{"url":"https://criteria.com", "description":"My Criteria"}","{"url":"https://criteria2.com", "description":"Other Criteria"}"} | [{"url": "https://criteria.com", "description": "My Criteria"}, {"url": "https://criteria2.com", "description": "Other Criteria"}] |
SELECT 1
ALTER TABLE
| criterias |
|---|
| [{"url": "https://criteria.com", "description": "My Criteria"}, {"url": "https://criteria2.com", "description": "Other Criteria"}] |
SELECT 1