Arbitrary whitespace restrictions on range types - Mailing list pgsql-bugs

From Josh Berkus
Subject Arbitrary whitespace restrictions on range types
Date
Msg-id 50D0FCC6.10905@agliodbs.com
Whole thread Raw
Responses Re: Arbitrary whitespace restrictions on range types
List pgsql-bugs
Jeff, Hackers:

Is there a strong reason why this has to error?

postgres=# select '[,]'::TSTZRANGE
postgres-# ;
 tstzrange
-----------
 (,)
(1 row)

postgres=# select '[, ]'::TSTZRANGE;
ERROR:  invalid input syntax for type timestamp with time zone: " "
LINE 1: select '[, ]'::TSTZRANGE

--Josh

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Postgres 9.2.2 Bug in Select with Left Join
Next
From: Peter Geoghegan
Date:
Subject: Re: Arbitrary whitespace restrictions on range types