- 24 Jul, 2005 7 commits
-
-
Tom Lane authored
Per Rocco Altier.
-
Tom Lane authored
-
Tom Lane authored
fails near DST transition days, so remove the advice about that testing problem. Also improve the description of variant-comparison-file selection.
-
Tom Lane authored
error message in Python 2.3 and before. Per Michael Fuhr and buildfarm results.
-
Bruce Momjian authored
interval_mul function.
-
Tom Lane authored
a lossy page has to be lossy, because we don't know exactly which tuples on the page should remain part of the bitmap. Per Jie Zhang.
-
Tom Lane authored
integration. Not clear this explains recent stats problems, but it's definitely wrong.
-
- 23 Jul, 2005 7 commits
-
-
Tom Lane authored
scans are candidates for exclusion; this should be fixed eventually. Simon Riggs, with some help from Tom Lane.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
near daylight savings time boudaries. This handles it properly, e.g. test=> select '2005-04-03 04:00:00'::timestamp at time zone 'America/Los_Angeles'; timezone ------------------------ 2005-04-03 07:00:00-04 (1 row)
-
Tom Lane authored
function that actually sleeps, instead of busy-waiting. Perhaps this will resolve some of the intermittent stats failures we keep seeing.
-
Bruce Momjian authored
test=> select (CURRENT_DATE + '05:00'::time)::timestamp at time zone 'Canada/Pacific'; timezone ------------------------ 2005-07-22 08:00:00-04 (1 row)
-
- 22 Jul, 2005 8 commits
-
-
Bruce Momjian authored
test=> select ('2005-07-20 00:00:00'::timestamp without time zone) at time zone 'Europe/Paris'; timezone ------------------------ 2005-07-19 22:00:00-04 Udpate documentation.
-
Tom Lane authored
-
Tom Lane authored
coding would ignore startup cost differences of less than 1% of the estimated total cost; which was OK for normal planning but highly not OK if a very small LIMIT was applied afterwards, so that startup cost becomes the name of the game. Instead, compare startup and total costs fuzzily but independently. This changes the plan selected for two queries in the regression tests; adjust expected-output files for resulting changes in row order. Per reports from Dawid Kuroczko and Sam Mason.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 21 Jul, 2005 9 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
Add SECS_PER_YEAR and MINS_PER_HOUR macros.
-
Bruce Momjian authored
-
Bruce Momjian authored
< > * Research storing disk pages with no alignment/padding
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
Add spaces where needed. Reference time interval variables as tinterval.
-
Tom Lane authored
calculations for interval and time/timetz to behave sanely for both integer and float timestamps; up to now I think it's been doing something pretty strange...
-
Bruce Momjian authored
#define DAYS_PER_YEAR 365.25 #define MONTHS_PER_YEAR 12 #define DAYS_PER_MONTH 30 #define HOURS_PER_DAY 24
-
- 20 Jul, 2005 5 commits
-
-
Tom Lane authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
24 hours. This is very helpful for daylight savings time: select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours'; ?column? ---------------------- 2005-05-04 01:00:00-04 select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day'; ?column? ---------------------- 2005-05-04 01:00:00-04 Michael Glaesemann
-
Bruce Momjian authored
test=> select '4 months'::interval / 5; ?column? --------------- 1 mon -6 days (1 row) after: test=> select '4 months'::interval / 5; ?column? ---------- 24 days (1 row) The problem was the use of rint() to round, and then find the remainder, causing the negative values.
-
- 19 Jul, 2005 1 commit
-
-
Neil Conway authored
an <xref/>.
-
- 18 Jul, 2005 3 commits
-
-
Tom Lane authored
for circle(polygon), which was missing; remove bogus entry for point(lseg, lseg), which does not exist, and the documentation seemed to describe lseg_interpt, which we already document as an operator not a function. Also remove entry for box_intersect, which likewise is preferentially used via the operator #.
-
Bruce Momjian authored
-
Bruce Momjian authored
-