| From: | James Robinson <james(at)jlr-photo(dot)com> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Documentation vs. allowed circle input formats |
| Date: | 2019-05-23 16:28:26 |
| Message-ID: | 68D58B47-12EA-4646-930B-3C85B25005C0@jlr-photo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
PG 11.3 docs <https://www.postgresql.org/docs/current/datatype-geometric.html#DATATYPE-CIRCLE> state that
'(x, y), r'
is a supported circle input format, but is not in reality:
# select '<(15, 15), 5>'::circle;
circle
-------------
<(15,15),5>
(1 row)
# select '((15, 15), 5)'::circle;
circle
-------------
<(15,15),5>
(1 row)
# select '15, 15, 5'::circle;
circle
-------------
<(15,15),5>
(1 row)
# select '(15, 15), 5'::circle;
ERROR: invalid input syntax for type circle: "(15, 15), 5"
LINE 1: select '(15, 15), 5'::circle;
I could produce a patch for either the documentation or the input function at the pleasure of a committer.
-----
James Robinson
james(at)jlr-photo(dot)com
http://jlr-photo.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2019-05-24 03:18:25 | BUG #15818: postgis ST_AsMVT function report [9913] ERROR: Missing libprotobuf-c |
| Previous Message | Tom Lane | 2019-05-23 15:27:33 | Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND |