| /dports/databases/postgresql96-server/postgresql-9.6.24/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql11-server/postgresql-11.14/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql12-client/postgresql-12.9/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|
| /dports/databases/postgresql13-pltcl/postgresql-13.5/contrib/earthdistance/sql/ |
| H A D | earthdistance.sql | 150 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,0))::numeric(20,5);
154 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))::numeric(20,5);
155 SELECT earth_distance(ll_to_earth(0,0),ll_to_earth(1,0))::numeric(20,5);
161 SELECT (earth_distance(ll_to_earth(41.8,87.6),ll_to_earth(35.1,106.7))*
226 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*1.00001) @>
229 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*1.00001) @>
232 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*1.00001) @>
257 earth_distance(ll_to_earth(0,0),ll_to_earth(0,1))*.57735) @>
260 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.1))*.57735) @>
263 earth_distance(ll_to_earth(0,0),ll_to_earth(0,0.01))*.57735) @>
[all …]
|