From 64568100787a5d03d036e70b32147385a35245e2 Mon Sep 17 00:00:00 2001
From: "Thomas G. Lockhart" <lockhart@fourpalms.org>
Date: Tue, 14 Mar 2000 23:06:59 +0000
Subject: Implement column aliases on views "CREATE VIEW name (collist)".
 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.

---
 src/test/regress/sql/numeric.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/test/regress/sql/numeric.sql')

diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql
index 2f4e4adefd4..3097cc5af7f 100644
--- a/src/test/regress/sql/numeric.sql
+++ b/src/test/regress/sql/numeric.sql
@@ -623,10 +623,10 @@ SELECT t1.id1, t1.result, t2.expected
     AND t1.result != t2.expected;
 
 -- ******************************
--- * POWER(10, LN(value)) check
+-- * POW(10, LN(value)) check
 -- ******************************
 DELETE FROM num_result;
-INSERT INTO num_result SELECT id, 0, POWER(numeric '10', LN(ABS(round(val,200))))
+INSERT INTO num_result SELECT id, 0, POW(numeric '10', LN(ABS(round(val,200))))
     FROM num_data
     WHERE val != '0.0';
 SELECT t1.id1, t1.result, t2.expected
-- 
cgit v1.2.3

