diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 2001-09-28 08:09:14 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 2001-09-28 08:09:14 +0000 |
| commit | 6f58115dddfa8ca63004c4784f57ef660422861d (patch) | |
| tree | 71816e03286e53113ec4b6de337f0b345028a314 /src/include/catalog/pg_opclass.h | |
| parent | 1f075a32ee28004251f508f50a4325944801da10 (diff) | |
| download | postgresql-6f58115dddfa8ca63004c4784f57ef660422861d.tar.gz | |
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.
Diffstat (limited to 'src/include/catalog/pg_opclass.h')
| -rw-r--r-- | src/include/catalog/pg_opclass.h | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/src/include/catalog/pg_opclass.h b/src/include/catalog/pg_opclass.h index 0b3b91758c..4b07349c0f 100644 --- a/src/include/catalog/pg_opclass.h +++ b/src/include/catalog/pg_opclass.h @@ -26,7 +26,7 @@ * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pg_opclass.h,v 1.39 2001/08/21 16:36:05 tgl Exp $ + * $Id: pg_opclass.h,v 1.40 2001/09/28 08:09:13 thomas Exp $ * * NOTES * the genbki.sh script reads this file and generates .bki @@ -127,12 +127,14 @@ DATA(insert OID = 1994 ( 403 text_ops 25 t 0 )); DATA(insert OID = 1995 ( 405 text_ops 25 t 0 )); DATA(insert OID = 1996 ( 403 time_ops 1083 t 0 )); DATA(insert OID = 1997 ( 405 time_ops 1083 t 0 )); -DATA(insert OID = 1998 ( 403 timestamp_ops 1184 t 0 )); -DATA(insert OID = 1999 ( 405 timestamp_ops 1184 t 0 )); +DATA(insert OID = 1998 ( 403 timestamptz_ops 1184 t 0 )); +DATA(insert OID = 1999 ( 405 timestamptz_ops 1184 t 0 )); DATA(insert OID = 2000 ( 403 timetz_ops 1266 t 0 )); DATA(insert OID = 2001 ( 405 timetz_ops 1266 t 0 )); DATA(insert OID = 2002 ( 403 varbit_ops 1562 t 0 )); DATA(insert OID = 2003 ( 403 varchar_ops 1043 t 0 )); DATA(insert OID = 2004 ( 405 varchar_ops 1043 t 0 )); +DATA(insert OID = 2039 ( 403 timestamp_ops 1114 t 0 )); +DATA(insert OID = 2040 ( 405 timestamp_ops 1114 t 0 )); #endif /* PG_OPCLASS_H */ |