PostgreSQL
念V伊人
Thought is already is late, exactly is the earliest time.
展开
-
PostgreSQL Json函数的简单使用示例
原始数据JSON 创建函数1.row_to_json文档描述函数描述例子例子结果row_to_json(record [, pretty_bool])把行作为一个 JSON 对象返回。如果pretty_bool为真,将在第1层元素之间增加换行。row_to_json(row(1,‘foo’)){“f1”:1,“f2”:“foo”}示例select unnest(Array[1,2,3]) as a;SELECT "Id","Name","Age","Cl原创 2021-03-27 17:44:04 · 929 阅读 · 0 评论 -
PostgreSQL数组函数的简单使用示例
原始数据unnest文档描述函数返回类型描述例子结果unnest(anyarray)setof anyelement将一个数组扩展成一组行unnest(ARRAY[1,2])12(2 rows)示例select unnest(Array[1,2,3]) as a;SELECT "Id","Name","Age","Class","Course","unnest"("Course") FROM "Students" WHERE "Id"=2官方文档原创 2021-03-27 17:00:50 · 586 阅读 · 0 评论 -
PostgreSQL 中json/jsonb类型数据的简单操作
-> 操作符右操作数类型为 intSELECT '[{"a":"foo"},{"b":"bar"},{"c":"baz"}]' ::json->2 as result;右操作数类型为 textSELECT '{"a":"ceshi","b":[1,2,3]}' ::json->'a' as result;SELECT '{"a":"ceshi","b":"[1,2,3]"}' ::json->'b' as result;->> 操作符右操作数类原创 2021-03-27 11:47:58 · 248 阅读 · 0 评论