On 26-2-2010 9:01, Helen Borrie wrote:

> At 05:53 PM 26/02/2010, you wrote:
>> Nevermind. Found the problem using ISQL - apparently Firebird 2.1
>> changes TIMESTAMP precision from seconds to 0.0001 seconds, which is
>> causing difference between my OLD.MODIFIED_ON (4 decimal places
>> precision) and NEW.MODIFIED_ON (rounded down to seconds).
>
> You must be talking about the CURRENT_TIMESTAMP subsecond precision (not the TIMESTAMP data type).

PostgreSQL also allows specifying precision on the TIMESTAMP data type.
(see http://www.postgresql.org/docs/8.4/static/datatype-datetime.html ).
It is also described in the SQL standard.

--
Mark Rotteveel