@@ -259,21 +259,21 @@ SELECT spoint(0.0 , 2.141592653589793116);
259
259
260
260
-- dist(spoint,spoint)
261
261
SELECT dist('( 0h 2m 30s , 0d 0m 0s)'::spoint,'( 0h 0m 30s , 0d 0m 0s)'::spoint);
262
- dist
263
- ---------------------
264
- 0.00872664625997165
262
+ dist
263
+ -------------------
264
+ 0.008726646259972
265
265
(1 row)
266
266
267
267
SELECT dist('( 0h 2m 30s , 0d 0m 0s)'::spoint,'( 0h 2m 30s , 10d 0m 0s)'::spoint);
268
- dist
269
- -------------------
270
- 0.174532925199433
268
+ dist
269
+ -----------------
270
+ 0.1745329251994
271
271
(1 row)
272
272
273
273
SELECT dist('( 0h 2m 30s , 0d 0m 0s)'::spoint,'( 0h 2m 30s , -10d 0m 0s)'::spoint);
274
- dist
275
- -------------------
276
- 0.174532925199433
274
+ dist
275
+ -----------------
276
+ 0.1745329251994
277
277
(1 row)
278
278
279
279
SELECT dist('( 0h 2m 30s , 95d 0m 0s)'::spoint,'( 12h 2m 30s , 85d 0m 0s)'::spoint);
@@ -283,9 +283,9 @@ SELECT dist('( 0h 2m 30s , 95d 0m 0s)'::spoint,'( 12h 2m 30s , 85d 0m 0s)'::spoi
283
283
(1 row)
284
284
285
285
SELECT dist('( 24h 2m 30s , 10d 0m 0s)'::spoint,'( 0h 2m 30s , -10d 0m 0s)'::spoint);
286
- dist
287
- -------------------
288
- 0.349065850398866
286
+ dist
287
+ -----------------
288
+ 0.3490658503989
289
289
(1 row)
290
290
291
291
SELECT dist('( 0h 2m 30s , 90d 0m 0s)'::spoint,'( 12h 2m 30s , 90d 0m 0s)'::spoint);
@@ -302,87 +302,87 @@ SELECT dist('( 0h 2m 30s , -90d 0m 0s)'::spoint,'( 12h 2m 30s , -90d 0m 0s)'::sp
302
302
303
303
-- long(spoint)
304
304
SELECT long('( 0h 2m 30s , 0d 0m 0s)'::spoint);
305
- long
306
- --------------------
307
- 0.0109083078249646
305
+ long
306
+ ------------------
307
+ 0.01090830782496
308
308
(1 row)
309
309
310
310
SELECT long('( 0h 2m 30s ,95d 0m 0s)'::spoint);
311
- long
312
- ------------------
313
- 3.15250096141476
311
+ long
312
+ ----------------
313
+ 3.152500961415
314
314
(1 row)
315
315
316
316
SELECT long('( 0h 2m 30s ,85d 0m 0s)'::spoint);
317
- long
318
- --------------------
319
- 0.0109083078249646
317
+ long
318
+ ------------------
319
+ 0.01090830782496
320
320
(1 row)
321
321
322
322
SELECT long('( 0h 2m 30s ,-95d 0m 0s)'::spoint);
323
- long
324
- ------------------
325
- 3.15250096141476
323
+ long
324
+ ----------------
325
+ 3.152500961415
326
326
(1 row)
327
327
328
328
SELECT long('( 0h 2m 30s ,-85d 0m 0s)'::spoint);
329
- long
330
- --------------------
331
- 0.0109083078249646
329
+ long
330
+ ------------------
331
+ 0.01090830782496
332
332
(1 row)
333
333
334
334
SELECT long('( 0h 2m 30s ,90d 0m 0s)'::spoint);
335
- long
336
- --------------------
337
- 0.0109083078249646
335
+ long
336
+ ------------------
337
+ 0.01090830782496
338
338
(1 row)
339
339
340
340
SELECT long('( 0h 2m 30s ,-90d 0m 0s)'::spoint);
341
- long
342
- --------------------
343
- 0.0109083078249646
341
+ long
342
+ ------------------
343
+ 0.01090830782496
344
344
(1 row)
345
345
346
346
SELECT long('(24h 2m 30s , 0d 0m 0s)'::spoint);
347
- long
348
- --------------------
349
- 0.0109083078249643
347
+ long
348
+ ------------------
349
+ 0.01090830782496
350
350
(1 row)
351
351
352
352
SELECT long('(24h 2m 30s ,95d 0m 0s)'::spoint);
353
- long
354
- ------------------
355
- 3.15250096141476
353
+ long
354
+ ----------------
355
+ 3.152500961415
356
356
(1 row)
357
357
358
358
SELECT long('(24h 2m 30s ,85d 0m 0s)'::spoint);
359
- long
360
- --------------------
361
- 0.0109083078249643
359
+ long
360
+ ------------------
361
+ 0.01090830782496
362
362
(1 row)
363
363
364
364
SELECT long('(24h 2m 30s ,-95d 0m 0s)'::spoint);
365
- long
366
- ------------------
367
- 3.15250096141476
365
+ long
366
+ ----------------
367
+ 3.152500961415
368
368
(1 row)
369
369
370
370
SELECT long('(24h 2m 30s ,-85d 0m 0s)'::spoint);
371
- long
372
- --------------------
373
- 0.0109083078249643
371
+ long
372
+ ------------------
373
+ 0.01090830782496
374
374
(1 row)
375
375
376
376
SELECT long('(24h 2m 30s ,90d 0m 0s)'::spoint);
377
- long
378
- --------------------
379
- 0.0109083078249643
377
+ long
378
+ ------------------
379
+ 0.01090830782496
380
380
(1 row)
381
381
382
382
SELECT long('(24h 2m 30s ,-90d 0m 0s)'::spoint);
383
- long
384
- --------------------
385
- 0.0109083078249643
383
+ long
384
+ ------------------
385
+ 0.01090830782496
386
386
(1 row)
387
387
388
388
-- lat(spoint)
@@ -393,39 +393,39 @@ SELECT lat('( 0h 2m 30s , 0d 0m 0s)'::spoint);
393
393
(1 row)
394
394
395
395
SELECT lat('( 0h 2m 30s ,95d 0m 0s)'::spoint);
396
- lat
397
- ------------------
398
- 1.48352986419518
396
+ lat
397
+ ----------------
398
+ 1.483529864195
399
399
(1 row)
400
400
401
401
SELECT lat('( 0h 2m 30s ,85d 0m 0s)'::spoint);
402
- lat
403
- ------------------
404
- 1.48352986419518
402
+ lat
403
+ ----------------
404
+ 1.483529864195
405
405
(1 row)
406
406
407
407
SELECT lat('( 0h 2m 30s ,-95d 0m 0s)'::spoint);
408
- lat
409
- -------------------
410
- -1.48352986419518
408
+ lat
409
+ -----------------
410
+ -1.483529864195
411
411
(1 row)
412
412
413
413
SELECT lat('( 0h 2m 30s ,-85d 0m 0s)'::spoint);
414
- lat
415
- -------------------
416
- -1.48352986419518
414
+ lat
415
+ -----------------
416
+ -1.483529864195
417
417
(1 row)
418
418
419
419
SELECT lat('( 0h 2m 30s ,90d 0m 0s)'::spoint);
420
- lat
421
- -----------------
422
- 1.5707963267949
420
+ lat
421
+ ----------------
422
+ 1.570796326795
423
423
(1 row)
424
424
425
425
SELECT lat('( 0h 2m 30s ,-90d 0m 0s)'::spoint);
426
- lat
427
- ------------------
428
- -1.5707963267949
426
+ lat
427
+ -----------------
428
+ -1.570796326795
429
429
(1 row)
430
430
431
431
SELECT lat('(24h 2m 30s , 0d 0m 0s)'::spoint);
@@ -435,39 +435,39 @@ SELECT lat('(24h 2m 30s , 0d 0m 0s)'::spoint);
435
435
(1 row)
436
436
437
437
SELECT lat('(24h 2m 30s ,95d 0m 0s)'::spoint);
438
- lat
439
- ------------------
440
- 1.48352986419518
438
+ lat
439
+ ----------------
440
+ 1.483529864195
441
441
(1 row)
442
442
443
443
SELECT lat('(24h 2m 30s ,85d 0m 0s)'::spoint);
444
- lat
445
- ------------------
446
- 1.48352986419518
444
+ lat
445
+ ----------------
446
+ 1.483529864195
447
447
(1 row)
448
448
449
449
SELECT lat('(24h 2m 30s ,-95d 0m 0s)'::spoint);
450
- lat
451
- -------------------
452
- -1.48352986419518
450
+ lat
451
+ -----------------
452
+ -1.483529864195
453
453
(1 row)
454
454
455
455
SELECT lat('(24h 2m 30s ,-85d 0m 0s)'::spoint);
456
- lat
457
- -------------------
458
- -1.48352986419518
456
+ lat
457
+ -----------------
458
+ -1.483529864195
459
459
(1 row)
460
460
461
461
SELECT lat('(24h 2m 30s ,90d 0m 0s)'::spoint);
462
- lat
463
- -----------------
464
- 1.5707963267949
462
+ lat
463
+ ----------------
464
+ 1.570796326795
465
465
(1 row)
466
466
467
467
SELECT lat('(24h 2m 30s ,-90d 0m 0s)'::spoint);
468
- lat
469
- ------------------
470
- -1.5707963267949
468
+ lat
469
+ -----------------
470
+ -1.570796326795
471
471
(1 row)
472
472
473
473
-- operators for points -------------
@@ -607,21 +607,21 @@ SELECT '( 0h 2m 30s , 0d 0m 0s)'::spoint<>'( 12h 2m 30s , 45d 0m 0s)'::spoint;
607
607
608
608
-- <-> operator ---------------------
609
609
SELECT '( 0h 2m 30s , 0d 0m 0s)'::spoint<->'( 0h 0m 30s , 0d 0m 0s)'::spoint;
610
- ?column?
611
- ---------------------
612
- 0.00872664625997165
610
+ ?column?
611
+ -------------------
612
+ 0.008726646259972
613
613
(1 row)
614
614
615
615
SELECT '( 0h 2m 30s , 0d 0m 0s)'::spoint<->'( 0h 2m 30s , 10d 0m 0s)'::spoint;
616
- ?column?
617
- -------------------
618
- 0.174532925199433
616
+ ?column?
617
+ -----------------
618
+ 0.1745329251994
619
619
(1 row)
620
620
621
621
SELECT '( 0h 2m 30s , 0d 0m 0s)'::spoint<->'( 0h 2m 30s , -10d 0m 0s)'::spoint;
622
- ?column?
623
- -------------------
624
- 0.174532925199433
622
+ ?column?
623
+ -----------------
624
+ 0.1745329251994
625
625
(1 row)
626
626
627
627
SELECT '( 0h 2m 30s , 95d 0m 0s)'::spoint<->'( 12h 2m 30s , 85d 0m 0s)'::spoint;
@@ -631,9 +631,9 @@ SELECT '( 0h 2m 30s , 95d 0m 0s)'::spoint<->'( 12h 2m 30s , 85d 0m 0s)'::spoint;
631
631
(1 row)
632
632
633
633
SELECT '( 24h 2m 30s , 10d 0m 0s)'::spoint<->'( 0h 2m 30s , -10d 0m 0s)'::spoint;
634
- ?column?
635
- -------------------
636
- 0.349065850398866
634
+ ?column?
635
+ -----------------
636
+ 0.3490658503989
637
637
(1 row)
638
638
639
639
SELECT '( 0h 2m 30s , 90d 0m 0s)'::spoint<->'( 12h 2m 30s , 90d 0m 0s)'::spoint;
0 commit comments