8000 Fix output precision limit for double values (issue #118) by vitcpp · Pull Request #119 · postgrespro/pgsphere · GitHub
[go: up one dir, main page]
Skip to content

Fix output precision limit for double values (issue #118) #119

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 4 commits into from
Mar 26, 2024
Merged

Fix output precision limit for double values (issue #118) #119

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
4 commits
Select commit Hold shift + click to select a range
b7e12f3
Fix output precision limit for double values (issue #118)
vitcpp Mar 14, 2024
c2116ae
Update upgrade script (reset_sphere_output_precision function)
vitcpp Mar 15, 2024
d9d5461
Add test for pgSphere output precision with different settings
vitcpp Mar 15, 2024
7b3b114
Add extra_float_digits = 2 for epochprop and bounding_box_gist tests
vitcpp Mar 18, 2024
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
8000
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Update upgrade script (reset_sphere_output_precision function)
  • Loading branch information
@vitcpp
vitcpp committed Mar 15, 2024
commit c2116ae86fc4c94a29ae714499ae2b62f35f3f67
6 changes: 5 additions & 1 deletion pgs_point.sql.in
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -26,6 +26,11 @@ CREATE FUNCTION set_sphere_output_precision(INT4)
AS 'MODULE_PATHNAME', 'set_sphere_output_precision'
LANGUAGE 'c';

CREATE FUNCTION reset_sphere_output_precision()
RETURNS CSTRING
AS 'MODULE_PATHNAME', 'reset_sphere_output_precision'
LANGUAGE 'c';

CREATE FUNCTION set_sphere_output(CSTRING)
RETURNS CSTRING
AS 'MODULE_PATHNAME', 'set_sphere_output'
Expand Down Expand Up @@ -175,4 +180,3 @@ CREATE OPERATOR <-> (

COMMENT ON OPERATOR <-> (spoint, spoint) IS
'distance between spherical points';

5 changes: 5 additions & 0 deletions upgrade_scripts/pg_sphere--1.4.2--1.5.0.sql.in
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -14,3 +14,8 @@ EXCEPTION
WHEN OTHERS THEN RAISE;
END;
$$;

CREATE FUNCTION reset_sphere_output_precision()
RETURNS CSTRING
AS 'MODULE_PATHNAME', 'reset_sphere_output_precision'
LANGUAGE 'c';
0