Re: storing TZ along timestamps

On Jul 21, 2011, at 2:39 PM, Jim Nasby wrote:

>> CREATE OR REPLACE FUNCTION is_timezone(
>>   tz CITEXT
>> ) RETURNS BOOLEAN LANGUAGE plpgsql STABLE AS $$
> ...
>> CREATE DOMAIN timezone AS CITEXT CHECK ( is_timezone( VALUE ) );
> 
> Storing giant globs of text with every timestamp field is really ugly.

You work with what you've got.

David