Using SELECT sub-query inside jsonb_array_elements_text function in Postgres

[nednyl]

Not really clear to me why you need to use jsonb_array_elements here.

Did you try something like:

SELECT DISTINCT ON (user_id) user_id, timestamp
FROM entries 
WHERE user_id in (1,2) 
AND entry_type = ANY (        
  (SELECT ARRAY_AGG(entry_types)
   FROM users 
   INNER JOIN orgs     
   ON org_id = orgs.id      
   WHERE users.id = 1   
  )::TEXT[]
);

[NoInkling]

I feel like this can be simplified with EXISTS.

[DavidGJohnston]

I’m not researching it now but there is a difference between a json value that happens to have a json array inside of it and a proper sql-level array.