aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/adt
Commit message (Collapse)AuthorAge
* Major revision of sort-node handling: push knowledge of queryTom Lane1999-08-21
| | | | | | | | | | | | | 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.
* Cleanups for int8: guard against null inputs in comparisonTom Lane1999-08-21
| | | | | operators (and some other places), fix rangechecks in int8 to int4 conversion (same problem we recently figured out in pg_atoi).
* Ooops ... I had left some test coding in selfuncs.c thatTom Lane1999-08-21
| | | | failed on 'field < textconstant' ...
* Store -1 in attdisbursion to signal 'no duplicates in column'.Tom Lane1999-08-09
| | | | Centralize att_disbursion readout logic.
* Further selectivity-estimation work. Speed up eqsel()Tom Lane1999-08-02
| | | | | | | | | (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.
* First step in fixing selectivity-estimation code. eqsel andTom Lane1999-08-01
| | | | | | | | | | 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.
* Alpha spinlock fix from Uncle George <gatgul@voicenet.com>Bruce Momjian1999-07-22
|
* Use -ieee alpha flag for gcc and egcs only.Bruce Momjian1999-07-20
|
* Re-add Makefile.Bruce Momjian1999-07-20
|
* Move -ieee to adt Makefile, and add CPU Makefile variable.Bruce Momjian1999-07-20
|
* Install new alignment code to use MAXALIGN rather than DOUBLEALIGN whereBruce Momjian1999-07-19
| | | | approproate.
* Move some system includes into c.h, and remove duplicates.Bruce Momjian1999-07-17
|
* Fix for multi-byte includes.Bruce Momjian1999-07-17
|
* Final cleanupBruce Momjian1999-07-16
|
* Final cleanup.Bruce Momjian1999-07-16
|
* Update #include cleanupsBruce Momjian1999-07-16
|
* Change #include's to use <> and "" as appropriate.Bruce Momjian1999-07-15
|
* Remove unused #includes in *.c files.Bruce Momjian1999-07-15
|
* Remove un-needed #include's from *.c files.Bruce Momjian1999-07-15
|
* Clean up #include in /include directory. Add scripts for checking includes.Bruce Momjian1999-07-15
|
* Cleanup of /include #include's, for 6.6 only.Bruce Momjian1999-07-14
|
* More cpu cleanups, only for 6.6.Bruce Momjian1999-07-13
|
* cleanup of long long int atoi test.Bruce Momjian1999-07-10
|
* Re-apply range check patch after fixing LIMIT_H test and defines.Bruce Momjian1999-07-09
|
* Another place that HAVE_LIMITS_H was misspelled.Tom Lane1999-07-09
|
* Fix for ACL length problem on different platforms.Bruce Momjian1999-07-09
|
* Backup pg_atoi patch for long checking. Caused initdb problems.Bruce Momjian1999-07-09
|
* > In both datetime_trunc() and timespan_trunc() in dt.c,Bruce Momjian1999-07-08
| | | | | | | | | > 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.
* pg_atoi() does range check on int4 data only ifBruce Momjian1999-07-08
| | | | | | | | | | | | "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.)
* Clarify maximum tuple and max attribute lengths.Bruce Momjian1999-07-04
|
* Fix to prevent too large tuple from being created.Bruce Momjian1999-07-03
|
* Temporarily disable error checks for missing selectivityTom Lane1999-06-19
| | | | | functions, in order to work around oversight in 6.5 release: rtree index functions haven't got any. Mea culpa ...
* Repair recently-introduced error in makeIndexable for LIKE:Tom Lane1999-06-07
| | | | | | 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.
* Changed "current." into "old." in rule string backparsingJan Wieck1999-06-02
| | | | Jan
* The INET and CIDR types mistakenly compared 198.68.123.0/24 andBruce Momjian1999-06-02
| | | | | | 198.68.123.0/27 the same when indexing them. D'Arcy
* Generate a more specific error message when an operator usedTom Lane1999-05-31
| | | | in an index doesn't have a restriction selectivity estimator.
* Make functions static or NOT_USED as appropriate.Bruce Momjian1999-05-26
|
* Another pgindent run. Sorry folks.Bruce Momjian1999-05-25
|
* Make 0x007f -> (unsigned)0x7f to make pgindent happy.Bruce Momjian1999-05-25
|
* pgindent run over code.Bruce Momjian1999-05-25
|
* Fixed bug in rules event qualification output.Jan Wieck1999-05-25
| | | | Jan
* FIx for 0.0.0.0/0 output as 00/0.Bruce Momjian1999-05-25
|
* Remove 4096 string limited key on block sizeBruce Momjian1999-05-19
|
* Fixed small bug in ruleutils and added output of pg_views andJan Wieck1999-05-12
| | | | | | pg_rules to rules regression test. Jan
* Replaced targetlist entry in GroupClause by reference numberJan Wieck1999-05-12
| | | | | | | in Resdom and GroupClause so changing of resno's doesn't confuse the grouping any more. Jan
* I am sorry, I misinterpreted the still failing trigger regression test.Bruce Momjian1999-05-12
| | | | | | | | | | | | | | | | | 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
* Check for NUMERIC overflow a second time after roundingJan Wieck1999-05-10
| | | | Jan
* Change error messages to oids come out as %u and not %d. Change has noBruce Momjian1999-05-10
| | | | real affect now.
* I have two patches for 6.5.0:Bruce Momjian1999-05-05
| | | | | | | | | | 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
* Use sprintf() to convert float8 to a string during conversion to numeric.Thomas G. Lockhart1999-05-04
| | | | | Original code used float8out(), but the resulting exponential notation was not handled (e.g. '3E9' was decoded as '3').
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-28 13:40:18 +0000