Search Results for: Drafting tables
imgaction":" },{"spm":"a","img":" sql statements support unstructured data types such as json, xml, and key-value, which enables a not only sql (nosql) solution.","tce_rule_count":" ","title":""},{"p":"for example, create table json_tab(id bigint, data jsonb);","tce_rule_count":" ","title":"create tables
using btree ((data ->> 'pname'));","tce_rule_count":" ","title":"index json attributes to enhance performance"},{"p":"for example, select * from json_tab join product on (products.pname=json_data.data->>'pname') where data->>'qty' > ;","tce_rule_count":" ","title":"perform join queries on existing tables...
https://www.alibabacloud.com/product/apsaradb-for-rds-postgresql