<story><title>PostgreSQL 9.2 beta adds JSON</title><url>http://www.h-online.com/open/news/item/PostgreSQL-9-2-beta-improves-scalability-adds-JSON-1573815.html</url></story><parent_chain></parent_chain><comment><author>stephen</author><text>Wow, range types with non-overlapping constraints:&lt;p&gt;&lt;a href=&quot;http://www.postgresql.org/docs/devel/static/rangetypes.html&quot; rel=&quot;nofollow&quot;&gt;http://www.postgresql.org/docs/devel/static/rangetypes.html&lt;/a&gt;&lt;p&gt;CREATE TABLE room_reservation (
  room TEXT,
  during TSRANGE,
  EXCLUDE USING gist (room WITH =, during WITH &amp;#38;&amp;#38;)
);&lt;p&gt;INSERT INTO room_reservation VALUES (&apos;123A&apos;, &apos;[2010-01-01 14:00, 2010-01-01 15:00)&apos;);&lt;p&gt;INSERT INTO room_reservation VALUES (&apos;123A&apos;, &apos;[2010-01-01 14:30, 2010-01-01 15:30)&apos;);
ERROR:  conflicting key value violates exclusion constraint &quot;room_reservation_room_during_excl&quot;
DETAIL:  Key (room, during)=(123A, [ 2010-01-01 14:30:00, 2010-01-01 15:30:00 )) conflicts with
existing key (room, during)=(123A, [ 2010-01-01 14:00:00, 2010-01-01 15:00:00 )).&lt;p&gt;Used to have to rely on the application to do these sorts of constraints.</text></comment>
<story><title>PostgreSQL 9.2 beta adds JSON</title><url>http://www.h-online.com/open/news/item/PostgreSQL-9-2-beta-improves-scalability-adds-JSON-1573815.html</url></story><parent_chain></parent_chain><comment><author>gphil</author><text>I think the bigger deal (at least for most existing deployments) are the index-only scans. This is one of the only features of Oracle that I missed after switching to Postgres.</text></comment>