Re: List of "binary-compatible" data types - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: List of "binary-compatible" data types
Date
Msg-id 52799542.7070104@agliodbs.com
Whole thread Raw
In response to Re: List of "binary-compatible" data types  (Josh Berkus <josh@agliodbs.com>)
Responses No-rewrite timestamp<->timestamptz conversions  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
Andres,

> There's zap chance of doing anything for 9.3, this would require quite a
> bit of code in tablecmds.c and that surely isn't going to happen in the
> backbranches.

Oh, sure, I was thinking of a workaround.

Actually, being able to separate "need to check contents" from "need to
rewrite values" could be useful for a lot of type conversions.

I'd also love some way of doing a no-rewrite conversion between
timestamp and timestamptz, based on the assumption that the original
values are UTC time.  That's one I encounter a lot.

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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Fast insertion indexes: why no developments
Next
From: Peter Eisentraut
Date:
Subject: git diff --check whitespace checks, gitattributes