gistfile1.txt

-> @> ->>
git rebase
chat 
// from sample_id 2383 : get list of siblings parent id (189, 190)
nb_slides 2
material parent id 'll_1'
local_lab_id_for_sample_1 'll_1'
local_lab_id_for_sample_2 'll_2'

// trouver les autres parent_id à partir d'un
  // generer la liste ('ll_1', 'll_2')
  // trouver le parent_id du premier sample dont le data.material_parent_id IN ('ll_1', 'll_2')
  
  
WITH tab_obj AS
(
    select * from json_each('{"local_lab_id_1": "aa_1", "local_lab_id_2": "bb_2", "uuu":"er"}')
) 
SELECT array_agg(value) FROM tab_obj
WHERE key LIKE 'local_lab_id_%'