![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
postgresql
文章平均质量分 73
z917185537
这个作者很懒,什么都没留下…
展开
-
postgresql数组查询
测试数据CREATE TABLE arr_test ( name text, color varchar[], size varchar[]);INSERT INTO arr_test VALUES ('adult_f','{"grey","black","white"}','{"s","m","l","xl","xxl"}'), ('adult_w','{"red","black","white","grey","blue"}','{"原创 2021-02-22 23:26:12 · 12685 阅读 · 0 评论 -
postgresql 分组查询
准备测试数据create table proc(name varchar(100),size varchar(30),color varchar(30),price money);insert into proc values('name_A','L','red',69),('name_A','M','red',86),('name_A','L','white',106),('name_A','s','',100),('name_A','s','black',100),('name_B'原创 2021-02-07 10:54:29 · 2614 阅读 · 0 评论