Documentation vs. allowed circle input formats

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: Raw Message | Whole Thread | 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/

Browse pgsql-bugs by date

  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