- 28 Sep, 2001 1 commit
-
-
Thomas G. Lockhart authored
Modify the timestamp test to reflect the "no time zone" behavior of this new code; timestamptz resembles the old timestamp code.
-
- 18 Jun, 2001 1 commit
-
-
Bruce Momjian authored
functions to clear date cache. Allow regression tests to pass when timezone set.
-
- 03 May, 2001 1 commit
-
-
Tom Lane authored
give consistent results for all datatypes. Types float4, float8, and numeric were broken for NaN values; abstime, timestamp, and interval were broken for INVALID values; timetz was just plain broken (some possible pairs of values were neither < nor = nor >). Also clean up text, bpchar, varchar, and bit/varbit to eliminate duplicate code and thereby reduce the probability of similar inconsistencies arising in the future.
-
- 25 Nov, 2000 1 commit
-
-
Bruce Momjian authored
it fixing Y,YY,YYY,YYYY conversion, the docs and regress tests update are included too. During the patch testing I found small bug in miscadmin.h in convertstr() declaration. Here it's fixed too. Thanks Karel
-
- 22 Sep, 2000 1 commit
-
-
Tom Lane authored
-
- 03 Jul, 2000 1 commit
-
-
Bruce Momjian authored
for to_char() too. Karel
-
- 01 Jul, 2000 2 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
Now the to_timestamp() support WW,W,J,SSSS,DDD conversion from strings and the am/pm bug is fixed, the to_char() use week-of-year (WW) full compatible with Oracle. This patch update relevant regress-tests and docs too. Karel ~ ~
-
- 09 Jun, 2000 1 commit
-
-
Bruce Momjian authored
-
- 07 Apr, 2000 1 commit
-
-
Bruce Momjian authored
-
- 16 Mar, 2000 1 commit
-
-
Thomas G. Lockhart authored
We probably support a superset of the spec, but I don't have the spec to confirm this. Update regression tests to include tests for this format. Update geometry.out with results from Linux RH 5.2 system (for last decimal place).
-
- 14 Mar, 2000 1 commit
-
-
Thomas G. Lockhart authored
Implement TIME WITH TIME ZONE type (timetz internal type). Remap length() for character strings to CHAR_LENGTH() for SQL92 and to remove the ambiguity with geometric length() functions. Keep length() for character strings for backward compatibility. Shrink stored views by removing internal column name list from visible rte. Implement min(), max() for time and timetz data types. Implement conversion of TIME to INTERVAL. Implement abs(), mod(), fac() for the int8 data type. Rename some math functions to generic names: round(), sqrt(), cbrt(), pow(), etc. Rename NUMERIC power() function to pow(). Fix int2 factorial to calculate result in int4. Enhance the Oracle compatibility function translate() to work with string arguments (from Edwin Ramirez). Modify pg_proc system table to remove OID holes.
-
- 08 Mar, 2000 1 commit
-
-
Bruce Momjian authored
the to_char() source code is large, here are regression tests for numeric/timestamp/int8 part. It is probably enough test for formatting code in the formatting.c module. The others (float4/float8/int4) types share this formatting code and eventual bugs for these types aren't few probable. Patch fix timestamp_to_char() for infinity/invalid timestamp too. Karel
-
- 16 Feb, 2000 1 commit
-
-
Thomas G. Lockhart authored
Implement "date/time grand unification". Transform datetime and timespan into timestamp and interval. Deprecate datetime and timespan, though translate to new types in gram.y. Transform all datetime and timespan catalog entries into new types. Make "INTERVAL" reserved word allowed as a column identifier in gram.y. Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility routines for all date/time types. date.{h,c} now deals with date, time types. timestamp.{h,c} now deals with timestamp, interval types. nabstime.{h,c} now deals with abstime, reltime, tinterval types. Make NUMERIC a known native type for purposes of type coersion. Not tested.
-
- 05 Jan, 2000 1 commit
-
-
Thomas G. Lockhart authored
Include a few new tests for datetime/timespan arithmetic.
-
- 15 Apr, 1999 1 commit
-
-
Thomas G. Lockhart authored
Previously, dates falling within Unix system time range were run through a call to localtime() to get the time zone, if it was not specified. This had the effect that dates with DOMs which were larger than would be valid for that month were "rotated" into the following months.
-
- 18 Jan, 1999 1 commit
-
-
Bruce Momjian authored
-
- 05 Jan, 1998 1 commit
-
-
Bruce Momjian authored
-
- 15 Nov, 1997 1 commit
-
-
Thomas G. Lockhart authored
on fast machines with fast disks. Adjust a few other tests to be more complete.
-
- 20 Sep, 1997 1 commit
-
-
Thomas G. Lockhart authored
-
- 01 Sep, 1997 1 commit
-
-
Thomas G. Lockhart authored
-
- 23 Jun, 1997 1 commit
-
-
Thomas G. Lockhart authored
This is compatible with abstime formats.
-
- 20 Jun, 1997 1 commit
-
-
Thomas G. Lockhart authored
datetime +/- timespan. Only manifested when date is at end of month and time pushes the date into the next month.
-
- 06 Jun, 1997 1 commit
-
-
Thomas G. Lockhart authored
-
- 11 May, 1997 1 commit
-
-
Thomas G. Lockhart authored
Add regression tests for circles, line segments, and paths. Modify regression tests to allow GEQ optimizer (order results).
-
- 27 Apr, 1997 1 commit
-
-
Marc G. Fournier authored
-