Postgres Pro
Downloads
Home   >   mailing lists

Documentation vs. allowed circle input formats - Mailing list pgsql-bugs

From James Robinson
Subject Documentation vs. allowed circle input formats
Date
Msg-id 68D58B47-12EA-4646-930B-3C85B25005C0@jlr-photo.com
Whole thread Raw
List pgsql-bugs
Tree view
PG 11.3 docs 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@jlr-photo.com
http://jlr-photo.com/



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND
Next
From: PG Bug reporting form
Date:
Subject: BUG #15818: postgis ST_AsMVT function report [9913] ERROR: Missing libprotobuf-c