OSDN Git Service

Measure the current transaction time to milliseconds.
authorThomas G. Lockhart <lockhart@fourpalms.org>
Fri, 28 Sep 2001 08:09:14 +0000 (08:09 +0000)
committerThomas G. Lockhart <lockhart@fourpalms.org>
Fri, 28 Sep 2001 08:09:14 +0000 (08:09 +0000)
commit6f58115dddfa8ca63004c4784f57ef660422861d
tree71816e03286e53113ec4b6de337f0b345028a314
parent1f075a32ee28004251f508f50a4325944801da10
Measure the current transaction time to milliseconds.
Define a new function, GetCurrentTransactionStartTimeUsec() to get the time
 to this precision.
Allow now() and timestamp 'now' to use this higher precision result so
 we now have fractional seconds in this "constant".
Add timestamp without time zone type.
Move previous timestamp type to timestamp with time zone.
Accept another ISO variant for date/time values: yyyy-mm-ddThh:mm:ss
 (note the "T" separating the day from hours information).
Remove 'current' from date/time types; convert to 'now' in input.
Separate time and timetz regression tests.
Separate timestamp and timestamptz regression test.
27 files changed:
src/backend/access/transam/xact.c
src/backend/parser/gram.y
src/backend/parser/parse_coerce.c
src/backend/parser/parse_expr.c
src/backend/parser/parse_target.c
src/backend/utils/adt/date.c
src/backend/utils/adt/datetime.c
src/backend/utils/adt/format_type.c
src/backend/utils/adt/formatting.c
src/backend/utils/adt/nabstime.c
src/backend/utils/adt/timestamp.c
src/include/access/xact.h
src/include/catalog/catversion.h
src/include/catalog/duplicate_oids
src/include/catalog/pg_aggregate.h
src/include/catalog/pg_amop.h
src/include/catalog/pg_amproc.h
src/include/catalog/pg_opclass.h
src/include/catalog/pg_operator.h
src/include/catalog/pg_proc.h
src/include/catalog/pg_type.h
src/include/utils/builtins.h
src/include/utils/date.h
src/include/utils/datetime.h
src/include/utils/formatting.h
src/include/utils/nabstime.h
src/include/utils/timestamp.h