SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE t_source_category ( id INT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, label varchar(255) NOT NULL, path varchar(255) NOT NULL, pid INT NOT NULL); INSERT INTO t_source_category (id, label, path, pid) VALUES (1, 'New York State', '1', 0), (2, 'New York City', '1,2', 1), (3, 'Manhattan', '1,2,3', 2); /* SELECT label FROM t_source_category WHERE id IN ( SELECT STRING_TO_ARRAY(path, ',')::INT[] FROM t_source_category WHERE id = 3 );*/ SELECT STRING_TO_ARRAY(path, ',')::INT[] FROM t_source_category WHERE id = 3; SELECT label FROM t_source_category WHERE id = ANY ( SELECT STRING_TO_ARRAY(path, ',')::INT[] FROM t_source_category WHERE id = 3 )::INT[];