aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/adt
Commit message (Collapse)AuthorAge
...
* Correct declaration of array_map() so that it doesn't makeTom Lane1999-05-03
| | | | gcc quite so unhappy.
* here are some patches for 6.5.0 which I already submitted but have neverBruce Momjian1999-05-03
| | | | | | | | | | | | | | | | | | | | | | | | | | | | been applied. The patches are in the .tar.gz attachment at the end: varchar-array.patch this patch adds support for arrays of bpchar() and varchar(), which where always missing from postgres. These datatypes can be used to replace the _char4, _char8, etc., which were dropped some time ago. block-size.patch this patch fixes many errors in the parser and other program which happen with very large query statements (> 8K) when using a page size larger than 8192. This patch is needed if you want to submit queries larger than 8K. Postgres supports tuples up to 32K but you can't insert them because you can't submit queries larger than 8K. My patch fixes this problem. The patch also replaces all the occurrences of `8192' and `1<<13' in the sources with the proper constants defined in include files. You should now never find 8192 hardwired in C code, just to make code clearer. -- Massimo Dal Zotto
* Fix compile failures in dt.c --- line broken in middle ofTom Lane1999-05-01
| | | | an identifier :-(. Sloppy transmission of a patch, likely.
* Bugfix (bug by me in 1.4) in backparsing INSERT ... SELECTJan Wieck1999-04-29
| | | | Jan
* Fix from Yutaka Tanida <yutaka@marin.or.jp> for Cygwin32 support.Tatsuo Ishii1999-04-26
|
* Portability patches for HPUX 11 and Unixware in configureTom Lane1999-04-20
| | | | | | and related files. Also remove float.c's gratuitous redeclaration of isinf() ... looks like there are more decls in there that ought to be in config.h, but I'll leave well enough alone for now ...
* Fix max(int8) result by making sure int8larger() copies its resultThomas G. Lockhart1999-04-15
| | | | | | | rather than reusing the input storage. Also made the same fix to int8smaller(), though there wasn't a symptom, and went through and verified that other pass-by-reference data types do the same thing. Not an issue for the by-value types.
* Fix code to check legal dates *before* calling localtime() to get theThomas G. Lockhart1999-04-15
| | | | | | | | time zone. Previously, localtime() rotated a date with a day of month field which exceeded the actual range into the next months, masking the fact that a bad date had been specified. Regression tests pass.
* Fix boolean assignment of return values to use "FALSE" rather than theThomas G. Lockhart1999-04-15
| | | | | mis-copied "NULL", which happens to have the same binary value. Previously, gcc gave non-fatal warnings.
* Version string was truncating the last character.Thomas G. Lockhart1999-04-06
| | | | | Use memcpy() rather than StrNCpy() which had forced a string termination character at the end.
* Fix bogus function signature for areajoinsel.Tom Lane1999-03-28
| | | | It still doesn't do anything, but at least now it does nothing correctly.
* Cleanup of NULL in inet types.Bruce Momjian1999-03-22
|
* This patch fixes the bug that made it impossible to grant permissions toBruce Momjian1999-03-21
| | | | | | a user such as "www-data". Oliver
* cleanupBruce Momjian1999-03-20
|
* cleanupsBruce Momjian1999-03-18
|
* LIKE cleanup.Bruce Momjian1999-03-15
|
* Fix brain death in !!= operator ... it's still pretty bogusTom Lane1999-03-15
| | | | but at least now it does what it's supposed to do ...
* > > > This patches src/bin/psql/psql.c.Bruce Momjian1999-03-15
| | | | | | | > > > > > > This patch is in responce to the following TODO list item: > > > * have psql \d on a view show the query > > > -Ryan
* src/backend/utils/adt/numeric.c fails to compile due to a string havingBruce Momjian1999-03-14
| | | | | | | | an embedded new-line character. Billy G. Allie
* Attempting to insert a value of 'now' into a datetime typeBruce Momjian1999-03-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | results in a bogus datetime value under AlphaLinux. (Note that the link to submit a port-specific bug on your website is broken) -Test Case: ---------- testdb=> create table dttest (dt datetime); testdb=> insert into dttest values ('now'); -------------------------------------------------------------------------- Solution: --------- The basic problem is the typedefs of AbsoluteTime and RelativeTime, which are both 'int32'. These types appear to be used synonymously with the 'time_t' type, which on AlphaLinux is typedef'd as a 'long int', which is 64-bits (not 32). The solution included here fixes the datetime type (it now passes the regression test), but does not pass the absolute and relative time regression tests. Presumably, a more thorough investigation of how these types are used is warranted. The included patch is from the v6.3.2 source, but can be applied to the v6.4.2 source. Please note that there is also a RedHat-specific patch distributed with the PostgreSQL source package from RedHat that was applied first. Rich Edwards
* Here is a little syntax error found in a .y file... A dropped semi.Bruce Momjian1999-03-14
| | | | | | DwD -- Daryl W. Dunbar
* We have tested the patches on three platforms:Bruce Momjian1999-03-14
| | | | | | | | | | | | | NetBSD/macppc LinuxPPC FreeBSD 2.2.6-RELEASE All of them seem happy with the regression test. Note that, however, compiling with optimization enabled on NetBSD/macppc causes an initdb failure (other two platforms are ok). After checking the asm code, we are suspecting that might be a compiler(egcs) bug. Tatsuo Ishii
* Thank you for the advice. I concluded that current inet code has aBruce Momjian1999-02-24
| | | | | | | | portability problem. Included patches should be applied to both current and 6.4 tree. I have tested on LinuxPPC, FreeBSD and Solaris 2.6. Now the inet regression tests on these platforms are all happy. --- Tatsuo Ishii
* From: Tatsuo Ishii <t-ishii@sra.co.jp>Marc G. Fournier1999-02-21
| | | | | | Ok. I made patches replacing all of "#if FALSE" or "#if 0" to "#ifdef NOT_USED" for current. I have tested these patches in that the postgres binaries are identical.
* regprocin should accept '-' signifying InvalidOid, forTom Lane1999-02-15
| | | | symmetry with regprocout.
* Change my-function-name-- to my_function_name, and optimizer renames.Bruce Momjian1999-02-13
|
* Fix offset of one for date_part(timespan) when given arguments ofThomas G. Lockhart1999-02-13
| | | | decade, century, or millenium.
* Change #if FALSE to #if NOT_USED to avoid port problems.Thomas G. Lockhart1999-02-13
| | | | | | Fix problem with date_part() for timespan (had an offset of one) when given decade, century, and millenium as arguments. Reported by Ricardo J.C.Coelho.
* Add routines to convert between int8 and text/varchar types.Thomas G. Lockhart1999-02-13
| | | | | Change #if FALSE to #if NOT_USED to avoid port problems. Fix up pg_indent weirdness with function argument declarations.
* Fix for returning stack pointer from selectivity, from Bernard Frankpitt.Bruce Momjian1999-02-05
|
* Cleanup of source files where 'return' or 'var =' is alone on a line.Bruce Momjian1999-02-03
|
* Modify int8 to not depend on sscanf(), and fix configure's testTom Lane1999-02-03
| | | | | | | | | | for int8 support. configure now checks only snprintf() for int8 support, not sprintf and sscanf as it used to. The reason for doing this is that if we are supplying our own snprintf code (which does handle long long int), we now only need working long long support in the compiler not in the platform's C library. I have verified that int8 now passes regression test on HPUX 9, and I think it should work on SunOS 4.1.* and other older platforms if gcc is used.
* Agg/Aggreg cleanup and datetime.sql patch.Bruce Momjian1999-01-25
|
* Rename Aggreg to Aggref.Bruce Momjian1999-01-24
|
* Improper addition of NaN/Infinity recognition to float8in()Tom Lane1999-01-24
| | | | | | | was causing it not to detect out-of-range float values, as evidenced by failure of float8 regression test. I corrected that logic and also modified expected float8 results to account for new error message generated for out-of-range inputs.
* FOR UPDATE is in parser & rules.Vadim B. Mikheev1999-01-21
|
* Fix "Y-2K" problem with two-digit BC dates being corrected by two millenia.Thomas G. Lockhart1999-01-20
| | | | | | They are not corrected now. Allow the date type to accept BC dates. Share more date/time validation declarations through dt.h.
* TCL_ARRAYS option patches from Massimo Dal ZottoTom Lane1999-01-17
|
* Apply Win32 patch from Horak Daniel.Bruce Momjian1999-01-17
|
* Fix for missing NAN.Bruce Momjian1999-01-17
|
* Be more careful to check input string lengths as well as valuesThomas G. Lockhart1999-01-10
| | | | | | | | | | | | | when deciding whether a field is a year field. Assume *anything* longer than 2 digits (if it isn't a special-case doy) is a valid year. This should fix the "Y1K" and "Y10K" problems pointed out by Massimo recently. Check usage of BC to require a positive-valued year; before just used it to flip the sign of the year without checking. This led to problems near year zero. Allow a 5 digit "concatenated date" of 2 digit year plus day of year. Do 2->4 digit year correction for 6 and 5 digit "concatenated dates". Somehow forgot this originally. Guess not many folks use it...
* Handle "NaN" and "Infinity" for input values.Thomas G. Lockhart1999-01-10
| | | | | | I think NAN is already guaranteed to be there from Jan's work on NUMERIC, but perhaps HUGE_VAL needs some #ifndef's in the same place. Should also include "-Infinity" as -HUGE_VAL sometime; not there yet.
* Removed precision restriction in numeric_round() causingJan Wieck1999-01-05
| | | | | | | overflow error on high precision calculations where temporary huge precision is required. Jan
* Just one more bugfix - this time in cmp_abs (cannot imagine thatJan Wieck1999-01-04
| | | | | | | taking a logarithm with a 400 digit precision worked with that bug in place). Jan
* Fixed backend crashing bug in apply_typmod()Jan Wieck1999-01-04
| | | | Jan
* Little fix for round() functionJan Wieck1999-01-04
| | | | Jan
* Fix NAN code.Bruce Momjian1999-01-03
|
* Fix for NAN generation.Bruce Momjian1999-01-03
|
* Fix for no platform NAN.Bruce Momjian1999-01-01
|
* Change ordering of HAVE_TM_ZONE and HAVE_INT_TIMEZONE code blocksThomas G. Lockhart1998-12-31
| | | | | | | | to give HAVE_TM_ZONE priority. This fixes glibc2 machines and any other machine which passes both tests in configure. Repair HAVE_TM_ZONE code which stuffs tm structure with date type values. Same problems as were originally there before v6.1, but never noticed. Thanks to Oleg for nagging :)