diff options
| author | Bruce Momjian <bruce@momjian.us> | 1999-07-08 03:22:46 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1999-07-08 03:22:46 +0000 |
| commit | 2cf2a4fe2be67b3be0d39d3713fadc906fb95877 (patch) | |
| tree | c4509ae3bbfcc38f707c333681775e173cc0f970 | |
| parent | 70ce98b77a75a95a22d816139f4e763c405310ea (diff) | |
| download | postgresql-2cf2a4fe2be67b3be0d39d3713fadc906fb95877.tar.gz postgresql-2cf2a4fe2be67b3be0d39d3713fadc906fb95877.zip | |
> In both datetime_trunc() and timespan_trunc() in dt.c,
> the DTK_MICROSEC case is just like the DTK_MILLISEC case.
> I think this is wrong and it ought to look like
> fsec = rint(fsec * 1000000) / 1000000;
> no?
Tom Lane.
| -rw-r--r-- | doc/TODO | 3 | ||||
| -rw-r--r-- | src/backend/utils/adt/dt.c | 6 |
2 files changed, 5 insertions, 4 deletions
@@ -93,7 +93,7 @@ TYPES * Allow LOCALE on a per-column basis, default to ASCII * Allow array on int8[] * Remove Money type, add money formatting for decimal type -* Fix typein/out functions to not be user-callable +* Declare typein/out functions in pg_proc with a special "C string" data type * Add non-large-object binary field * Add index on NUMERIC type @@ -190,6 +190,7 @@ INDEXES * Improve LIMIT processing by using index to limit rows processed * Have optimizer take LIMIT into account when considering index scans * Make index creation use psort code, because it is now faster(Vadim) +* Allow creation of sort temp tables > 1 Gig * Create more system table indexes for faster cache lookups * fix indexscan() so it does leak memory by not requiring caller to free * Improve _bt_binsrch() to handle equal keys better, remove _bt_firsteq()(Tom) diff --git a/src/backend/utils/adt/dt.c b/src/backend/utils/adt/dt.c index 9fb75cb5687..74028c439a3 100644 --- a/src/backend/utils/adt/dt.c +++ b/src/backend/utils/adt/dt.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/Attic/dt.c,v 1.71 1999/05/25 16:12:00 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/Attic/dt.c,v 1.72 1999/07/08 03:22:46 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -1429,7 +1429,7 @@ datetime_trunc(text *units, DateTime *datetime) break; case DTK_MICROSEC: - fsec = rint(fsec * 1000) / 1000; + fsec = rint(fsec * 1000000) / 1000000; break; default: @@ -1573,7 +1573,7 @@ timespan_trunc(text *units, TimeSpan *timespan) break; case DTK_MICROSEC: - fsec = rint(fsec * 1000) / 1000; + fsec = rint(fsec * 1000000) / 1000000; break; default: |