Arbitrary whitespace restrictions on range types

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>
Subject: Arbitrary whitespace restrictions on range types
Date: 2012-12-18 23:31:18
Message-ID: 50D0FCC6.10905@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2012-12-19 00:06:29 Re: Arbitrary whitespace restrictions on range types
Previous Message Kevin Grittner 2012-12-18 20:46:18 Re: Postgres 9.2.2 Bug in Select with Left Join