地理空间数据库
琉璃浅雪
地信专业。。。条条大路通CS can't agree more
展开
-
SQL查询 查询不在随机正整数表中的最小正整数
select min(ap) answer from ( ( select A+1 ap from ( select A from (select A from T) T1 union (select A-A A from T))T2 )原创 2016-04-14 15:00:32 · 455 阅读 · 0 评论 -
SQL/POSTGIS 使用函数实现ST_Intersects
create or replace function ST_LineIntersects(x1 float, y1 float, x2 float, y2 float, x3 float, y3 float, x4 float, y4 float) returns boolean as $$ declare a1 float; a2 float; b1 f原创 2016-05-08 21:28:48 · 2202 阅读 · 0 评论