Re: storing TZ along timestamps

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Jim Nasby <jim(at)nasby(dot)net>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: storing TZ along timestamps
Date: 2011-07-21 21:44:17
Message-ID: C4B20998-C9F2-434B-BEBD-56310C7BDE59@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2011-07-21 21:48:27 Re: storing TZ along timestamps
Previous Message Jim Nasby 2011-07-21 21:44:14 Re: storing TZ along timestamps