• 用户榜
• 标签榜
• 冲榜分奖金

## 频道

• 4

回答

• 30

浏览

2天前
• 3

回答

• 23

浏览

pg萌新求教 从表中取三个不同的character varying类型的数据，如何插入字符串数组中 上代码 create or replace function bus_transfer_only() returns character varying as \$\$ declare i integer; j integer; d integer; frog integer; res_gid1 character varying(24)[]; res_puid1 character varying(24)[]; res_luid1 character varying(24)[]; res_gid2 character varying(24)[]; res_puid2 character varying(24)[]; res_luid2 character varying(24)[]; begin i := 0; j := 0; frog := 0; execute 'select t.gid, t.pointuid, t.lineuid from dalian_bus_point t where st_distanceSphere( st_setsrid(geom,4326), ST_GeometryFromText(''point(121.533143938637 38.891021094920)'',4326)) <=2500 order by ST_DistanceSphere( geom, ST_GeometryFromText(''point(121.533143938637 38.891021094920)'',4326)) limit 150' into res_gid1, res_puid1, res_luid1; execute 'select t.*, from dalian_bus_point t where st_distanceSphere( st_setsrid(geom,4326), ST_GeometryFromText(''point(121.628355729643 38.9211884963126)'',4326)) <=1500 order by ST_DistanceSphere( geom, ST_GeometryFromText(''point(121.628355729643 38.9211884963126)'',4326)) limit 150' into res_gid2, res_puid2, res_luid2; 因为 limit 150 所以我这样写肯定不对，但是我也不知道其他办法 还有如果以上查询有效率更高的写法，也欢迎贴出来一起学习

4天前
• 3

回答

• 13

浏览

1.数据库中每个箱号对应着10个不同的单箱号 2.如何查找出箱号对应不足10个单箱号的箱号 3.两个字段均在一张表中

19天前
• 4

回答

• 24

浏览

21天前
• 4

回答

• 45

浏览

21天前