Bret Hughes <[EMAIL PROTECTED]> writes:
> create function int2ts(integer) returns timestamp as '
> SELECT ( TIMESTAMP WITH TIME ZONE \'epoch\' + $1 * INTERVAL \'1
> second\')::timestamp without time zone;
> ' language sql;
> create function ts2int(timestamp without time zone) returns int as '
> select extract( \'epoch\' from $1)::integer;
> ' language sql;
Looks good as far as it goes. Two thoughts:
* both functions should probably be marked STRICT STABLE
(not IMMUTABLE, because they depend on the local timezone setting).
* have you considered allowing the numeric values to be float8 instead
of integer? There doesn't seem any reason to disallow sub-second
precision.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
