summaryrefslogtreecommitdiff
path: root/src/backend/utils/adt/float.c
AgeCommit message (Collapse)Author
2000-04-12Ye-old pgindent run. Same 4-space tabs.Bruce Momjian
2000-04-07Add transcendental math functions (sine, cosine, etc)Thomas G. Lockhart
Add a random number generator and seed setter (random(), SET SEED) Fix up the interval*float8 math to carry partial months into the time field. Add float8*interval so we have symmetry in the available math. Fix the parser and define.c to accept SQL92 types as field arguments. Fix the parser to accept SQL92 types for CREATE TYPE, etc. This is necessary to allow... Bit/varbit support in contrib/bit cleaned up to compile and load cleanly. Still needs some work before final release. Implement the "SOME" keyword as a synonym for "ANY" per SQL92. Implement ascii(text), ichar(int4), repeat(text,int4) to help support the ODBC driver. Enable the TRUNCATE() function mapping in the ODBC driver.
2000-03-23Float-to-int conversion functions should return NULL when given NULLTom Lane
input, not throw a gratuitous elog().
2000-03-14Implement column aliases on views "CREATE VIEW name (collist)".Thomas G. Lockhart
Implement TIME WITH TIME ZONE type (timetz internal type). Remap length() for character strings to CHAR_LENGTH() for SQL92 and to remove the ambiguity with geometric length() functions. Keep length() for character strings for backward compatibility. Shrink stored views by removing internal column name list from visible rte. Implement min(), max() for time and timetz data types. Implement conversion of TIME to INTERVAL. Implement abs(), mod(), fac() for the int8 data type. Rename some math functions to generic names: round(), sqrt(), cbrt(), pow(), etc. Rename NUMERIC power() function to pow(). Fix int2 factorial to calculate result in int4. Enhance the Oracle compatibility function translate() to work with string arguments (from Edwin Ramirez). Modify pg_proc system table to remove OID holes.
2000-01-26Add:Bruce Momjian
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc to all files copyright Regents of Berkeley. Man, that's a lot of files.
2000-01-15Fixed all elog related warnings, as well as a few others.Peter Eisentraut
1999-12-20Finally found a platform which has finite() but nonetheless sets errnoTom Lane
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.
1999-10-02Replace float.c's #ifdef finite check with a proper autoconf check, so itTom Lane
works if finite() is a function. Patch from Christof Petig.
1999-09-26Modify nodeAgg.c so that no rows are returned for a GROUP BYTom Lane
with no input rows, per pghackers discussions around 7/22/99. Clean up a bunch of ugly coding while at it; remove redundant re-lookup of aggregate info at start of each new GROUP. Arrange to pfree intermediate values when they are pass-by-ref types, so that aggregates on pass-by-ref types no longer eat memory. This takes care of a couple of TODO items...
1999-09-21values.h patch from Alex HowanskyBruce Momjian
1999-07-17 Move some system includes into c.h, and remove duplicates.Bruce Momjian
1999-07-16Update #include cleanupsBruce 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-05-25pgindent run over code.Bruce Momjian
1999-04-20Portability patches for HPUX 11 and Unixware in configureTom Lane
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 ...
1999-02-13Change my-function-name-- to my_function_name, and optimizer renames.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-17Fix for missing NAN.Bruce Momjian
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.
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-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-09-01OK, folks, here is the pgindent output.Bruce Momjian
1998-09-01Renaming cleanup, no pgindent yet.Bruce Momjian
1998-04-27From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>Marc G. Fournier
Ok, I have finally gotten all of the defines for Dec/Alpha and Linux/Alpha sorted out as Marc asked. There is no longer any need for '-Dalpha' or '-Dlinuxalpha' in either the Dec/Alpha or the Linux/Alpha template files (./src/template/{alpha,linuxalpha}). I have replaced every instance of 'alpha' or '__alpha__' with '__alpha', as that appears to be the common symbol between C compilers on both operating systems (RH4.2 & DecUnix 4.0b) for alpha.
1998-04-12More work in the right direction on linux/alphaMarc G. Fournier
From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>
1998-02-26pgindent run before 6.3 release, with Thomas' requested changes.Bruce Momjian
1998-02-02Move all the isinf() stuff from float.c to isinf.c, and build it according toMarc G. Fournier
configure vs port specific #ifdef's...
1998-01-13Various cleanups for the i386_solaris environmentMarc G. Fournier
1998-01-05Change some ABORTS to ERROR. Add line number when COPY Failure.Bruce Momjian
1998-01-05Change elog(WARN) to elog(ERROR) and elog(ABORT).Bruce Momjian
1997-09-26AIX float fix.Bruce Momjian
1997-09-24Remove extra float.h I added.Bruce Momjian
1997-09-23AIX fixes.Bruce Momjian
1997-09-13Fix up error messages to remove extra newline. Use "zero" rather than "0.0".Thomas G. Lockhart
1997-09-08Used modified version of indent that understands over 100 typedefs.Bruce Momjian
1997-09-08Another PGINDENT run that changes variable indenting and case label ↵Bruce Momjian
indenting. Also static variable indenting.
1997-09-07Massive commit to run PGINDENT on all *.c and *.h files.Bruce Momjian
1997-07-28Added SCO support, from Daniel Harris.Bruce Momjian
1997-06-03Use finite() macro if available to check returns from pow() and exp().Thomas G. Lockhart
1997-05-14Rename new float and int conversion routines to avoid conflicts withThomas G. Lockhart
system calls on AIX (and probably other machines too).
1997-05-11Fix timezone manipulation code to avoid crashes on some machines.Thomas G. Lockhart
Add type conversion functions for floating point numbers. Check for zero in unary minus floating point code (IEEE allows an explicit negative zero which looks ugly in a query result!). Ensure circle type has non-negative radius.
1997-03-12From: Dan McGuirk <mcguirk@indirect.com>Marc G. Fournier
Subject: [HACKERS] linux/alpha patches These patches lay the groundwork for a Linux/Alpha port. The port doesn't actually work unless you tweak the linker to put all the pointers in the first 32 bits of the address space, but it's at least a start. It implements the test-and-set instruction in Alpha assembly, and also fixes a lot of pointer-to-integer conversions, which is probably good anyway.
1997-02-19Prevent under/over flow of float8 constants in parser. Small regression fix.Bruce Momjian
1997-02-14Remove WIN32 defines. They never worked.Bruce Momjian
1997-01-24Convert NEED_{RINT,CBRT,ISINF} to HAVE_* in prepration for configure...Marc G. Fournier
1997-01-18Add missing #.Bruce Momjian
1997-01-06Minor changes for NeXT compileMarc G. Fournier
Submitted by: Ovidiu Predescu <ovidiu@bx.logicnet.ro>