Changes between Initial Version and Version 1 of Ticket #4223, comment 2


Ignore:
Timestamp:
Nov 5, 2018, 12:03:46 PM (6 years ago)
Author:
pramsey

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4223, comment 2

    initial v1  
    1 Just stripping the example down to a smaller one for the debugger
    2 {{{
    3 SELECT
    4         _ST_DistanceTree(g1, g2),
    5         _ST_DistanceUncached(g1, g2)
    6 FROM
    7         (SELECT
    8                 ST_Transform(ST_GeomFromText('POLYGON((-5  0, -5 100, 5 100, 5 0, -5 0))',32641),4326)::geography AS g1,
    9                 ST_Transform(ST_GeomFromText('POLYGON((-10  30, -10  40, -20  40, -20  30, -10  30))',32641),4326)::geography AS g2
    10         ) AS f1
    11 }}}
     1WITH g AS (
     2SELECT
     3  'POLYGON((58.5112113206308 0,58.5112113200772 0.000901937525203378,58.511300910044 0.000901937636668872,58.5113009105976 0,58.5112113206308 0))'::geography AS a,
     4  'POLYGON((58.5111665256017 0.000270581240841207,58.5111665255629 0.000360774987788249,58.5110769356128 0.000360774943200728,58.5110769356515 0.000270581207400566,58.5111665256017 0.000270581240841207))'::geography AS b
     5 )
     6 SELECT _ST_DistanceTree(a, b), _ST_DistanceUncached(a, b)
     7 FROM g;