On Jul 19, 2011, at 2:06 PM, Josh Berkus wrote:
> I am strongly in favor of having a *timezone* data type and some system
> whereby we can uniquely identify timezones in the Zic database.
CREATE OR REPLACE FUNCTION is_timezone( tz CITEXT
) RETURNS BOOLEAN LANGUAGE plpgsql STABLE AS $$
BEGIN PERFORM NOW() AT TIME ZONE tz; RETURN TRUE;
EXCEPTION WHEN invalid_parameter_value THEN RETURN FALSE;
END;
$$;
CREATE DOMAIN timezone AS CITEXT CHECK ( is_timezone( VALUE ) );
Best,
David
