Horton

Re: List of "binary-compatible" data types

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: Josh Berkus <josh@agliodbs.com>
To: Noah Misch <noah@leadboat.com>
Cc: Thom Brown <thom@linux.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2013-11-05T18:00:15Z
Lists: pgsql-hackers 
Noah,

>> Also, JSON <--> Text seems to be missing from the possible binary
>> conversions.  That's a TODO, I suppose.
> 
> Only json --> text, not json <-- text.  Note that you can add the cast
> manually if you have an immediate need.

Huh?  Why would text --> JSON require a physical rewrite?  We have to
validate it, sure, but we don't need to rewrite it.

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

Commits

  1. Avoid some table rewrites for ALTER TABLE .. SET DATA TYPE timestamp.

  2. Disable transforms that replaced AT TIME ZONE with RelabelType.

  3. Add transform functions for AT TIME ZONE.