summaryrefslogtreecommitdiff
path: root/src/backend/utils/adt
AgeCommit message (Collapse)Author
1999-03-15LIKE cleanup.Bruce Momjian
1999-03-15Fix brain death in !!= operator ... it's still pretty bogusTom Lane
but at least now it does what it's supposed to do ...
1999-03-15> > > This patches src/bin/psql/psql.c.Bruce Momjian
> > > > > > This patch is in responce to the following TODO list item: > > > * have psql \d on a view show the query > > > -Ryan
1999-03-14src/backend/utils/adt/numeric.c fails to compile due to a string havingBruce Momjian
an embedded new-line character. Billy G. Allie
1999-03-14Attempting to insert a value of 'now' into a datetime typeBruce Momjian
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
1999-03-14Here is a little syntax error found in a .y file... A dropped semi.Bruce Momjian
DwD -- Daryl W. Dunbar
1999-03-14We have tested the patches on three platforms:Bruce Momjian
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
1999-02-24Thank you for the advice. I concluded that current inet code has aBruce Momjian
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
1999-02-21From: Tatsuo Ishii <t-ishii@sra.co.jp>Marc G. Fournier
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.
1999-02-15regprocin should accept '-' signifying InvalidOid, forTom Lane
symmetry with regprocout.
1999-02-13Change my-function-name-- to my_function_name, and optimizer renames.Bruce Momjian
1999-02-13Fix offset of one for date_part(timespan) when given arguments ofThomas G. Lockhart
decade, century, or millenium.
1999-02-13Change #if FALSE to #if NOT_USED to avoid port problems.Thomas G. Lockhart
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.
1999-02-13Add routines to convert between int8 and text/varchar types.Thomas G. Lockhart
Change #if FALSE to #if NOT_USED to avoid port problems. Fix up pg_indent weirdness with function argument declarations.
1999-02-05Fix for returning stack pointer from selectivity, from Bernard Frankpitt.Bruce Momjian
1999-02-03Cleanup of source files where 'return' or 'var =' is alone on a line.Bruce Momjian
1999-02-03Modify int8 to not depend on sscanf(), and fix configure's testTom Lane
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.
1999-01-25Agg/Aggreg cleanup and datetime.sql patch.Bruce Momjian
1999-01-24Rename Aggreg to Aggref.Bruce Momjian
1999-01-24Improper addition of NaN/Infinity recognition to float8in()Tom Lane
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.
1999-01-21FOR UPDATE is in parser & rules.Vadim B. Mikheev
1999-01-20Fix "Y-2K" problem with two-digit BC dates being corrected by two millenia.Thomas G. Lockhart
They are not corrected now. Allow the date type to accept BC dates. Share more date/time validation declarations through dt.h.
1999-01-17TCL_ARRAYS option patches from Massimo Dal ZottoTom Lane
1999-01-17Apply Win32 patch from Horak Daniel.Bruce Momjian
1999-01-17Fix for missing NAN.Bruce Momjian
1999-01-10Be more careful to check input string lengths as well as valuesThomas G. Lockhart
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...
1999-01-10Handle "NaN" and "Infinity" for input values.Thomas G. Lockhart
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.
1999-01-05Removed precision restriction in numeric_round() causingJan Wieck
overflow error on high precision calculations where temporary huge precision is required. Jan
1999-01-04Just one more bugfix - this time in cmp_abs (cannot imagine thatJan Wieck
taking a logarithm with a 400 digit precision worked with that bug in place). Jan
1999-01-04Fixed backend crashing bug in apply_typmod()Jan Wieck
Jan
1999-01-04Little fix for round() functionJan Wieck
Jan
1999-01-03Fix NAN code.Bruce Momjian
1999-01-03Fix for NAN generation.Bruce Momjian
1999-01-01Fix for no platform NAN.Bruce Momjian
1998-12-31Change ordering of HAVE_TM_ZONE and HAVE_INT_TIMEZONE code blocksThomas G. Lockhart
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 :)
1998-12-30Little precision fix for POWER(). I discovered problems with bigJan Wieck
exponents. Jan
1998-12-30Added NUMERIC data type with many builtin funcitons, operatorsJan Wieck
and aggregates. Jan
1998-12-15Oops, sorry...meant to commit the patch from Thomas for tzn->CTZNameMarc G. Fournier
1998-12-15tzn undeclared in FreeBSD, commented out.Vadim B. Mikheev
1998-12-15Initial MVCC code.Vadim B. Mikheev
New code for locking buffer' context.
1998-12-14more cleanups...of note, appendStringInfo now performs like sprintf(),Marc G. Fournier
where you state a format and arguments. the old behavior required each appendStringInfo to have to have a sprintf() before it if any formatting was required. Also shortened several instances where there were multiple appendStringInfo() calls in a row, doing nothing more then adding one more word to the String, instead of doing them all in one call.
1998-12-13Add routines to help with single-byte (internal) character type support.Thomas G. Lockhart
1998-12-13Switch around conditional code so that HAVE_TM_ZONE takes precedenceThomas G. Lockhart
over HAVE_INT_TIMEZONE. This may help out linux/glibc2 and Dec Alpha. Included #error precompiler macros to catch cases where neither is defined but USE_POSIX_TIME is (shouldn't happen). Hopefully this isn't just a gcc-ism.
1998-12-08Define routines and catalog entries for string min()/max() functions.Thomas G. Lockhart
Extend new type coersion techniques to aggregates. Clean up a few elog() messages.
1998-11-29Change exp() behavior to generate error on underflow ratherTom Lane
than silently returning zero on some machines. Correct float8 regress test to agree. Also fix pow() overflow/underflow check to work correctly on HPUX.
1998-11-27New HeapTuple structure/interface.Vadim B. Mikheev
1998-11-17Add text<->float8 and text<->float4 conversion functions.Thomas G. Lockhart
This will fix the problem reported by Jose' Soares when trying to cast a float to text.
1998-10-29Very minor cleanup of no-op code.Thomas G. Lockhart
1998-10-29Add oid8neq.Bruce Momjian
1998-10-29Re-fix test for negative-integer return code that should beTom Lane
testing for null-pointer return code...