summaryrefslogtreecommitdiff
path: root/src/backend/utils/adt
AgeCommit message (Collapse)Author
1999-08-21Major revision of sort-node handling: push knowledge of queryTom Lane
sort order down into planner, instead of handling it only at the very top level of the planner. This fixes many things. An explicit sort is now avoided if there is a cheaper alternative (typically an indexscan) not only for ORDER BY, but also for the internal sort of GROUP BY. It works even when there is no other reason (such as a WHERE condition) to consider the indexscan. It works for indexes on functions. It works for indexes on functions, backwards. It's just so cool... CAUTION: I have changed the representation of SortClause nodes, therefore THIS UPDATE BREAKS STORED RULES. You will need to initdb.
1999-08-21Cleanups for int8: guard against null inputs in comparisonTom Lane
operators (and some other places), fix rangechecks in int8 to int4 conversion (same problem we recently figured out in pg_atoi).
1999-08-21Ooops ... I had left some test coding in selfuncs.c thatTom Lane
failed on 'field < textconstant' ...
1999-08-09Store -1 in attdisbursion to signal 'no duplicates in column'.Tom Lane
Centralize att_disbursion readout logic.
1999-08-02Further selectivity-estimation work. Speed up eqsel()Tom Lane
(it should just call the given operator, not look up an = operator). Fix intltsel() so that all numeric data types are converted to double before trying to estimate where the given comparison value is in the known range of column values. intltsel() still needs work, or replacement, for non-numeric data types ... but for nonintegral numeric types it should now be delivering reasonable estimates.
1999-08-01First step in fixing selectivity-estimation code. eqsel andTom Lane
neqsel now behave as per my suggestions in pghackers a few days ago. selectivity for < > <= >= should work OK for integral types as well, but still need work for nonintegral types. Since these routines have never actually executed before :-(, this may result in some significant changes in the optimizer's choices of execution plans. Let me know if you see any serious misbehavior. CAUTION: THESE CHANGES REQUIRE INITDB. pg_statistic table has changed.
1999-07-22Alpha spinlock fix from Uncle George <gatgul@voicenet.com>Bruce Momjian
1999-07-20Use -ieee alpha flag for gcc and egcs only.Bruce Momjian
1999-07-20Re-add Makefile.Bruce Momjian
1999-07-20Move -ieee to adt Makefile, and add CPU Makefile variable.Bruce Momjian
1999-07-19Install new alignment code to use MAXALIGN rather than DOUBLEALIGN whereBruce Momjian
approproate.
1999-07-17 Move some system includes into c.h, and remove duplicates.Bruce Momjian
1999-07-17Fix for multi-byte includes.Bruce Momjian
1999-07-16Final cleanupBruce Momjian
1999-07-16Final cleanup.Bruce Momjian
1999-07-16Update #include cleanupsBruce Momjian
1999-07-15Change #include's to use <> and "" as appropriate.Bruce Momjian
1999-07-15Remove unused #includes in *.c files.Bruce Momjian
1999-07-15Remove un-needed #include's from *.c files.Bruce Momjian
1999-07-15Clean up #include in /include directory. Add scripts for checking includes.Bruce Momjian
1999-07-14Cleanup of /include #include's, for 6.6 only.Bruce Momjian
1999-07-13More cpu cleanups, only for 6.6.Bruce Momjian
1999-07-10cleanup of long long int atoi test.Bruce Momjian
1999-07-09Re-apply range check patch after fixing LIMIT_H test and defines.Bruce Momjian
1999-07-09Another place that HAVE_LIMITS_H was misspelled.Tom Lane
1999-07-09Fix for ACL length problem on different platforms.Bruce Momjian
1999-07-09Backup pg_atoi patch for long checking. Caused initdb problems.Bruce Momjian
1999-07-08> In both datetime_trunc() and timespan_trunc() in dt.c,Bruce Momjian
> 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.
1999-07-08pg_atoi() does range check on int4 data only ifBruce Momjian
"HAS_LONG_LONG" is defined based on the assumption that strtol() would return ERANGE if a platform does not support 64-bit integers. In current PostgreSQL 6.5 (and 6.4.2) distribution, "HAS_LONG_LONG" is defined only if platform is "alpha". (See include/port/alpha.h) I think the int4 range check should apply to linux_alpha as well. (I have not tested yet but I guess this might be applicable to newer Linux/i386 distributions which includes new GCC which implements long int as 64-bit int.)
1999-07-04Clarify maximum tuple and max attribute lengths.Bruce Momjian
1999-07-03Fix to prevent too large tuple from being created.Bruce Momjian
1999-06-19Temporarily disable error checks for missing selectivityTom Lane
functions, in order to work around oversight in 6.5 release: rtree index functions haven't got any. Mea culpa ...
1999-06-07Repair recently-introduced error in makeIndexable for LIKE:Tom Lane
a non-leading % would be put into the >=/<= patterns. Also, repair longstanding confusion about whether %% means a literal %%. The SQL92 doesn't say any such thing, and textlike() knows that, but gram.y didn't.
1999-06-02Changed "current." into "old." in rule string backparsingJan Wieck
Jan
1999-06-02The INET and CIDR types mistakenly compared 198.68.123.0/24 andBruce Momjian
198.68.123.0/27 the same when indexing them. D'Arcy
1999-05-31Generate a more specific error message when an operator usedTom Lane
in an index doesn't have a restriction selectivity estimator.
1999-05-26Make functions static or NOT_USED as appropriate.Bruce Momjian
1999-05-25Another pgindent run. Sorry folks.Bruce Momjian
1999-05-25Make 0x007f -> (unsigned)0x7f to make pgindent happy.Bruce Momjian
1999-05-25pgindent run over code.Bruce Momjian
1999-05-25Fixed bug in rules event qualification output.Jan Wieck
Jan
1999-05-25FIx for 0.0.0.0/0 output as 00/0.Bruce Momjian
1999-05-19Remove 4096 string limited key on block sizeBruce Momjian
1999-05-12Fixed small bug in ruleutils and added output of pg_views andJan Wieck
pg_rules to rules regression test. Jan
1999-05-12Replaced targetlist entry in GroupClause by reference numberJan Wieck
in Resdom and GroupClause so changing of resno's doesn't confuse the grouping any more. Jan
1999-05-12I am sorry, I misinterpreted the still failing trigger regression test.Bruce Momjian
The offending code has been removed, the action is now always dependent :-) I suggest the following patch, to finally make trigger regression happy again: <<refint1.patch>> After that you can remove the following from TODO: Remove ERROR: check_primary_key: even number of arguments should be specified Trigger regression test fails Andreas
1999-05-10Check for NUMERIC overflow a second time after roundingJan Wieck
Jan
1999-05-10Change error messages to oids come out as %u and not %d. Change has noBruce Momjian
real affect now.
1999-05-05I have two patches for 6.5.0:Bruce Momjian
arrayfuncs.patch fixes a small bug in my previous patches for arrays array-regress.patch adds _bpchar and _varchar to regression tests -- Massimo Dal Zotto
1999-05-04Use sprintf() to convert float8 to a string during conversion to numeric.Thomas G. Lockhart
Original code used float8out(), but the resulting exponential notation was not handled (e.g. '3E9' was decoded as '3').