summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/float8.sql
Commit message (Collapse)AuthorAgeFilesLines
* Remove grammar productions for prefix and postfix % and ^ operators,Tom Lane2005-06-081-2/+2
| | | | | | | | | | as well as the existing pg_catalog entries for prefix and postfix %. These have never been documented, though they did appear in one old regression test. This avoids surprising behavior in cases like "SELECT -25 % -10". Per recent discussion. Note: although there is a catalog change here, I did not force initdb since there's no harm in leaving the inaccessible entries in one's copy of pg_operator.
* Add a "USING" clause to DELETE, which is equivalent to the FROM clauseNeil Conway2005-04-071-4/+4
| | | | | | | | | | | | | | | in UPDATE. We also now issue a NOTICE if a query has _any_ implicit range table entries -- in the past, we would only warn about implicit RTEs in SELECTs with at least one explicit RTE. As a result of the warning change, 25 of the regression tests had to be updated. I also took the opportunity to remove some bogus whitespace differences between some of the float4 and float8 variants. I believe I have correctly updated all the platform-specific variants, but let me know if that's not the case. Original patch for DELETE ... USING from Euler Taveira de Oliveira, reworked by Neil Conway.
* Adjust input routines for float4, float8 and oid to reject the empty stringNeil Conway2005-02-111-0/+1
| | | | | as valid input (it was previously treated as 0). This input was deprecated in 8.0 (and a warning was emitted). Regression tests updated.
* Add ceiling() as an alias for ceil(), and power() as an alias for pow().Neil Conway2004-04-231-1/+5
| | | | | | | | | | | | | | Regression tests and documentation have both been updated. SQL2003 requires that both ceiling() and ceil() be present, so I have documented both spellings. SQL2003 doesn't mention pow() as far as I can see, so I decided to replace pow() with power() in the documentation: there is little reason to encourage the continued usage of a function that isn't compliant with the standard, given a standard-compliant alternative. RELEASE NOTES: should state that pow() is considered deprecated (although I don't see the need to ever remove it.)
* Update the float8 regression tests: they should now pass on FreeBSD 4.xNeil Conway2004-03-241-5/+5
| | | | and (in theory) QNX. Thanks to Chris KL for the report.
* Allow 'Infinity' and '-Infinity' as input to the float4 and float8Neil Conway2004-03-121-0/+8
| | | | | | | | | types. Update the regression tests and the documentation to reflect this. Remove the UNSAFE_FLOATS #ifdef. This is only half the story: we still unconditionally reject floating point operations that result in +/- infinity. See recent thread on -hackers for more information.
* Revise int2/int4/int8/float4/float8 input routines to allow forNeil Conway2004-03-111-7/+24
| | | | | | | | | | any amount of leading or trailing whitespace (where "whitespace" is defined by isspace()). This is for SQL conformance, as well as consistency with other numeric types (e.g. oid, numeric). Also refactor pg_atoi() to avoid looking at errno where not necessary, and add a bunch of regression tests for the input to these types.
* This patch adds some missing functions for float8 math operations,Bruce Momjian2002-10-191-1/+10
| | | | | | | | specifically ceil(), floor(), and sign(). There may be other functions that need to be added, but this is a start. I've included some simple regression tests. Neil Conway
* Convert float8 regress test to use exp() and ln() instead of ':' andTom Lane2000-03-201-4/+4
| | | | ';' operators.
* Implement column aliases on views "CREATE VIEW name (collist)".Thomas G. Lockhart2000-03-141-1/+7
| | | | | | | | | | | | | | | | | | 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.
* Clean up syntax to use SQL92-ish type coersionThomas G. Lockhart2000-01-041-1/+3
| | | | | rather than the Postgres "::" notation. All of these tests have been completely inspected and give correct results.
* Here are some patches to fix up the regression tests so that the unionBruce Momjian1998-09-221-9/+26
| | | | | | | | | | test passes. Interestingly, the fix involves no changes or special cases in the union test and actually removes a special case for the numerology test. Thus, following the strategy outlined below is a definite improvement over the previous situation. Cheers, Brook
* Add inter-type regression tests for geometry, date/time, and numbers.Thomas G. Lockhart1997-05-111-1/+0
| | | | | Add regression tests for circles, line segments, and paths. Modify regression tests to allow GEQ optimizer (order results).
* Make these self-contained tests...they are testing types, so the tablesMarc G. Fournier1997-04-271-1/+1
| | | | | | that are created should only exist as long as the test requires them... things are just toooooo spread around
* Again, add more testsMarc G. Fournier1997-04-051-0/+104
View Lorry Controller Status