summaryrefslogtreecommitdiff
path: root/src/backend/utils/adt
Commit message (Collapse)AuthorAgeFilesLines
* numeric_in accepts exponents; numeric to int4 rounds; float4/8 to numericTom Lane2000-01-181-480/+259
| | | | | | is considerably more robust and accurate than it used to be. Also, get rid of numeric's private allocation freelist, which is no longer a win since Jan rewrote palloc.
* setheapoverride() is history. Uses replaced with CommandCounterIncrement()Tom Lane2000-01-171-3/+1
| | | | | where necessary --- several of them didn't really need it, though. tqual-checking macros simplified accordingly.
* Clean up problems with rounding/overflow code in NUMERIC, particularlyTom Lane2000-01-151-75/+109
| | | | | the case wherein zero was rejected for a field like NUMERIC(4,4). Miscellaneous other code beautification efforts.
* Fix a passel of problems with incorrect calls to typinput and typoutputTom Lane2000-01-153-12/+14
| | | | | | | functions, which would lead to trouble with datatypes that paid attention to the typelem or typmod parameters to these functions. In particular, incorrect code in pg_aggregate.c explains the platform-specific failures that have been reported in NUMERIC avg().
* Fixed all elog related warnings, as well as a few others.Peter Eisentraut2000-01-1512-95/+96
|
* More cleanups.Bruce Momjian2000-01-111-2/+2
|
* Make number of args to a function configurable.Bruce Momjian2000-01-102-12/+11
|
* Rename oid8 -> oidvector and int28 -> int2vector. Cleanup of *out functions.Bruce Momjian2000-01-104-26/+26
|
* Update int28out and out8out and _in_ functions to handle trailing zerosBruce Momjian2000-01-102-25/+46
| | | | properly.
* Fix oid8in and int28in for spacesBruce Momjian2000-01-102-4/+6
|
* Move fixes for >8 indexed fields.Bruce Momjian2000-01-101-20/+17
|
* Move INDEX_MAX_KEYS to postgres.h, and make it configurable for users.Bruce Momjian2000-01-101-23/+20
|
* Another round of planner/optimizer work. This is just restructuring andTom Lane2000-01-091-7/+14
| | | | | code cleanup; no major improvements yet. However, EXPLAIN does produce more intuitive outputs for nested loops with indexscans now...
* Sorry, that I send this letter/patch again, but previous sending isBruce Momjian2000-01-072-2/+130
| | | | | | | | | still without answer. I want continue with to_char(), but I need any answer for this patch. Please. Thank! (and sorry of my impatient :-) Karel
* Changed "triggered data change violation" detection codeJan Wieck2000-01-061-1/+124
| | | | | | in trigger manager. Jan
* Fixed bug in targetlist expression replacement ofJan Wieck2000-01-061-4/+11
| | | | | | SET DEFAULT referential action triggers. Jan
* Fix it's and its to be correct.Bruce Momjian2000-01-052-6/+6
|
* Repair two recently reported problems:Thomas G. Lockhart2000-01-041-8/+12
| | | | | | | | | | | | | | | | 1) datetime_pl_span() added the seconds field before adding the months field. This lead to erroneous results for e.g. select datetime '1999-11-30' + timespan '1 mon - 1 sec'; Reverse the order of operations to add months first. 2) tm2timespan() did all intermediate math as integer, converting to double at the very end. This resulted in hidden overflows when given very large integer days, hours, etc. For example, select '74565 days'::timespan; produced the wrong result. Change code to ensure that doubles are used for intermediate calculations. Thanks to Olivier PRENANT <ohp@pyrenet.fr> and Tulassay Zsolt <zsolt@tek.bke.hu> for problem reports and to Tom Lane for accurate analyses.
* Update DATEDEBUG removal.Bruce Momjian2000-01-021-8/+3
|
* Remove DATEDEBUG because it didn't look Y2K safe, and fix timestamp elogBruce Momjian2000-01-024-384/+5
| | | | to be Y2K safe.
* Repair bugs discussed in pghackers thread of 15 May 1999: creation of aTom Lane1999-12-301-2/+1
| | | | | | relcache entry no longer leaks a small amount of memory. index_endscan now releases all the memory acquired by index_beginscan, so callers of it should NOT pfree the scan descriptor anymore.
* Removed LZTEXT datatype as discussed.Jan Wieck1999-12-282-3/+3
| | | | Jan
* Clean up handling of explicit NULL constants. Cases likeTom Lane1999-12-241-7/+14
| | | | | | | | | | | | | SELECT null::text; SELECT int4fac(null); work as expected now. In some cases a NULL must be surrounded by parentheses: SELECT 2 + null; fails SELECT 2 + (null); OK This is a grammatical ambiguity that seems difficult to avoid. Other than that, NULLs seem to behave about like you'd expect. The internal implementation is that NULL constants are typed as UNKNOWN (like untyped string constants) until the parser can deduce the right type.
* This patch will avoid SIGFPE on some geo functions , if PostgreSQL is compiledBruce Momjian1999-12-211-2/+5
| | | | | | | | | | | with DEC C. DEC C doesn't handle double values greater than DBL_MAX, but some PostgreSQL geo functions assign greater than DBL_MAX values to some vars in some special cases - that couses SIGFPE. I dunno if that is the only place to fix to work well with DEC C. Kirill Nosov.
* Finally found a platform which has finite() but nonetheless sets errnoTom Lane1999-12-201-15/+18
| | | | | | | rather than returning a NaN for bogus input to pow(). Namely, HPUX 10.20. I think this is sufficient evidence for what I thought all along, which is that the float.c code *must* look at errno whether finite() exists or not.
* Clean up some minor gcc warnings.Tom Lane1999-12-201-3/+3
|
* Some changes to prepare for LONG attributes.Jan Wieck1999-12-161-1/+3
| | | | Jan
* Ethernet MAC addresses (macaddr type) are not compared correctly forBruce Momjian1999-12-161-2/+2
| | | | | | | | | | | | | | | equality. The lobits macro is wrong and extracts the wrong set of bits out of the structure. To exhibit the problem: select '000000:000000'::macaddr = '000000:110000'::macaddr ; ?column? -------- t (1 row) Daniel Boyd
* New LDOUT makefile variable for QNX os.Bruce Momjian1999-12-131-2/+2
|
* aggregate(DISTINCT ...) works, per SQL spec.Tom Lane1999-12-131-4/+8
| | | | Note this forces initdb because of change of Aggref node in stored rules.
* Added global variable to have RI triggers overrideJan Wieck1999-12-101-1/+10
| | | | | | time qualification of HeapTupleSatisfiesSnapshot() Jan
* Make LD -r as macros that can be changed for QNX.Bruce Momjian1999-12-091-2/+2
|
* Update for QNX from Kardos, Dr. AndreaBruce Momjian1999-12-092-2/+8
|
* Hi,Bruce Momjian1999-12-092-6/+24
| | | | | | | | | | | | | | | | I was able to crash postgres 6.5.3 when I did an 'alter user' command. After I started a debugger I found the problem in the timezone handling of datetime (my Linux box lost its timezone information, that's how the problem occurred). Only 7 bytes are reserved for the timezone, without checking for boundaries. Attached is a patch that fixes this problem and emits a NOTICE if a timezone is encountered that is longer than MAXTZLEN bytes, like this: Jeroen van Vianen
* Fixed concurrent visibility bug.Jan Wieck1999-12-081-2/+12
| | | | Jan
* Again updated INSIDE TODOJan Wieck1999-12-071-5/+4
| | | | Jan
* Added SET DEFAULT action for ON DELETE/UPDATEJan Wieck1999-12-071-16/+479
| | | | Jan
* Corrected TODO in sourceJan Wieck1999-12-061-3/+1
| | | | Jan
* Added ON DELETE/UPDATE SET NULLJan Wieck1999-12-061-18/+411
| | | | Jan
* Completed FOREIGN KEY syntax.Jan Wieck1999-12-061-23/+630
| | | | | | | | Added functionality for automatic trigger creation during CREATE TABLE. Added ON DELETE RESTRICT and some others. Jan
* Rule deparser needs to quote identifiers that are spelled the same asTom Lane1999-12-061-3/+19
| | | | SQL keywords.
* Fix for bool casting.Bruce Momjian1999-11-251-2/+2
|
* Added another single byte oriented decompressor, useful forJan Wieck1999-11-252-2/+309
| | | | | | | | | comparision functions. Added all lztext comparision functions, operators and a default operator class for nbtree on lztext. Jan
* Add opid to selectivity function call.Bruce Momjian1999-11-251-6/+7
|
* Enable pg_statistic cache use.Bruce Momjian1999-11-251-13/+5
|
* Add pg_statistic index, add missing Hiroshi file.Bruce Momjian1999-11-242-5/+5
|
* Add multi-byte support to lztextlen()Tatsuo Ishii1999-11-241-4/+25
|
* Rename heap_replace to heap_update.Bruce Momjian1999-11-241-2/+2
|
* Add system indexes to match all caches.Bruce Momjian1999-11-227-26/+26
| | | | | | | Make all system indexes unique. Make all cache loads use system indexes. Rename *rel to *relid in inheritance tables. Rename cache names to be clearer.
* Some minor corrections to the LZ compression. In fact I wanted toJan Wieck1999-11-172-11/+20
| | | | | | HAVE the required OID's first. Jan
View Lorry Controller Status