![]() Movie_json_test=> explain analyze select imdb_id, title, imdb_rating, t.* from movies_json_generated, jsonb_to_recordset(jsonb_column->'cast') as t(id text,name varchar(100),character text) where name like 'Robert Downey%' and jsonb_column->'cast'::text != 'null' limit 5 Movie_json_test=> select imdb_id, title, imdb_rating, t.* from movies_json_generated, jsonb_to_recordset(jsonb_column->'cast') as t(id text,name varchar(100),character text) where name like 'Robert Downey%' and jsonb_column->'cast'::text != 'null' limit 5 Tt2395427 | Avengers: Age of Ultron (2015) | 7.50 | nm1093951 | Aaron Taylor-Johnson | Pietro Maximoff Tt2395427 | Avengers: Age of Ultron (2015) | 7.50 | nm0424060 | Scarlett Johansson | Natasha Romanoff Imdb_id | title | imdb_rating | id | name | character ![]() Movie_json_test=> select imdb_id, title, imdb_rating, t.* from movies_json_generated, jsonb_to_recordset(jsonb_column->'cast') as t(id text,name text,character text) where imdb_id = 'tt2395427' limit 15 ![]() "description": "based on the Marvel comics by" "description": "based on the Marvel comics by and" "title": "Avengers: Age of Ultron (2015)",
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |