aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress')
-rw-r--r--src/test/regress/expected/boolean.out2
-rw-r--r--src/test/regress/expected/case.out2
-rw-r--r--src/test/regress/expected/strings.out8
-rw-r--r--src/test/regress/input/constraints.source2
-rw-r--r--src/test/regress/output/constraints.source2
-rw-r--r--src/test/regress/sql/boolean.sql2
-rw-r--r--src/test/regress/sql/case.sql2
-rw-r--r--src/test/regress/sql/strings.sql8
8 files changed, 14 insertions, 14 deletions
diff --git a/src/test/regress/expected/boolean.out b/src/test/regress/expected/boolean.out
index e39f550332e..463278dca19 100644
--- a/src/test/regress/expected/boolean.out
+++ b/src/test/regress/expected/boolean.out
@@ -366,7 +366,7 @@ SELECT '' AS tf_12_ff_4, BOOLTBL1.*, BOOLTBL2.*
(16 rows)
--
--- SQL92 syntax
+-- SQL syntax
-- Try all combinations to ensure that we get nothing when we expect nothing
-- - thomas 2000-01-04
--
diff --git a/src/test/regress/expected/case.out b/src/test/regress/expected/case.out
index 9ec32b8bd26..c564eedb948 100644
--- a/src/test/regress/expected/case.out
+++ b/src/test/regress/expected/case.out
@@ -163,7 +163,7 @@ SELECT '' AS "Five",
--
-- NULLIF() and COALESCE()
-- Shorthand forms for typical CASE constructs
--- defined in the SQL92 standard.
+-- defined in the SQL standard.
--
SELECT * FROM CASE_TBL WHERE COALESCE(f,i) = 4;
i | f
diff --git a/src/test/regress/expected/strings.out b/src/test/regress/expected/strings.out
index 1bd6772ddd4..b87bd8024bc 100644
--- a/src/test/regress/expected/strings.out
+++ b/src/test/regress/expected/strings.out
@@ -2,7 +2,7 @@
-- STRINGS
-- Test various data entry syntaxes.
--
--- SQL92 string continuation syntax
+-- SQL string continuation syntax
-- E021-03 character string literals
SELECT 'first line'
' - next line'
@@ -272,7 +272,7 @@ SELECT CAST(name 'namefield' AS varchar) AS "varchar(name)";
(1 row)
--
--- test SQL92 string functions
+-- test SQL string functions
-- E### and T### are feature reference numbers from SQL99
--
-- E021-09 trim function
@@ -1076,7 +1076,7 @@ alter table toasttest alter column f1 set storage external;
insert into toasttest values(repeat('1234567890',10000));
insert into toasttest values(repeat('1234567890',10000));
-- If the starting position is zero or less, then return from the start of the string
--- adjusting the length to be consistent with the "negative start" per SQL92.
+-- adjusting the length to be consistent with the "negative start" per SQL.
SELECT substr(f1, -1, 5) from toasttest;
substr
--------
@@ -1126,7 +1126,7 @@ alter table toasttest alter column f1 set storage external;
insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
-- If the starting position is zero or less, then return from the start of the string
--- adjusting the length to be consistent with the "negative start" per SQL92.
+-- adjusting the length to be consistent with the "negative start" per SQL.
SELECT substr(f1, -1, 5) from toasttest;
substr
--------
diff --git a/src/test/regress/input/constraints.source b/src/test/regress/input/constraints.source
index 16468b20afb..2a630378882 100644
--- a/src/test/regress/input/constraints.source
+++ b/src/test/regress/input/constraints.source
@@ -119,7 +119,7 @@ INSERT INTO INSERT_TBL(y) VALUES ('Y');
SELECT 'eight' AS one, currval('insert_seq');
--- According to SQL92, it is OK to insert a record that gives rise to NULL
+-- According to SQL, it is OK to insert a record that gives rise to NULL
-- constraint-condition results. Postgres used to reject this, but it
-- was wrong:
INSERT INTO INSERT_TBL VALUES (null, null, null);
diff --git a/src/test/regress/output/constraints.source b/src/test/regress/output/constraints.source
index ff6c1dc450d..18a5dd8ab19 100644
--- a/src/test/regress/output/constraints.source
+++ b/src/test/regress/output/constraints.source
@@ -188,7 +188,7 @@ SELECT 'eight' AS one, currval('insert_seq');
eight | 8
(1 row)
--- According to SQL92, it is OK to insert a record that gives rise to NULL
+-- According to SQL, it is OK to insert a record that gives rise to NULL
-- constraint-condition results. Postgres used to reject this, but it
-- was wrong:
INSERT INTO INSERT_TBL VALUES (null, null, null);
diff --git a/src/test/regress/sql/boolean.sql b/src/test/regress/sql/boolean.sql
index d92a41ffe11..5c46fb92fcf 100644
--- a/src/test/regress/sql/boolean.sql
+++ b/src/test/regress/sql/boolean.sql
@@ -164,7 +164,7 @@ SELECT '' AS tf_12_ff_4, BOOLTBL1.*, BOOLTBL2.*
ORDER BY BOOLTBL1.f1, BOOLTBL2.f1;
--
--- SQL92 syntax
+-- SQL syntax
-- Try all combinations to ensure that we get nothing when we expect nothing
-- - thomas 2000-01-04
--
diff --git a/src/test/regress/sql/case.sql b/src/test/regress/sql/case.sql
index fd5c4002442..5f41753337d 100644
--- a/src/test/regress/sql/case.sql
+++ b/src/test/regress/sql/case.sql
@@ -110,7 +110,7 @@ SELECT '' AS "Five",
--
-- NULLIF() and COALESCE()
-- Shorthand forms for typical CASE constructs
--- defined in the SQL92 standard.
+-- defined in the SQL standard.
--
SELECT * FROM CASE_TBL WHERE COALESCE(f,i) = 4;
diff --git a/src/test/regress/sql/strings.sql b/src/test/regress/sql/strings.sql
index 6ef446308b5..89ba46fd999 100644
--- a/src/test/regress/sql/strings.sql
+++ b/src/test/regress/sql/strings.sql
@@ -3,7 +3,7 @@
-- Test various data entry syntaxes.
--
--- SQL92 string continuation syntax
+-- SQL string continuation syntax
-- E021-03 character string literals
SELECT 'first line'
' - next line'
@@ -92,7 +92,7 @@ SELECT CAST(f1 AS varchar) AS "varchar(char)" FROM CHAR_TBL;
SELECT CAST(name 'namefield' AS varchar) AS "varchar(name)";
--
--- test SQL92 string functions
+-- test SQL string functions
-- E### and T### are feature reference numbers from SQL99
--
@@ -345,7 +345,7 @@ insert into toasttest values(repeat('1234567890',10000));
insert into toasttest values(repeat('1234567890',10000));
-- If the starting position is zero or less, then return from the start of the string
--- adjusting the length to be consistent with the "negative start" per SQL92.
+-- adjusting the length to be consistent with the "negative start" per SQL.
SELECT substr(f1, -1, 5) from toasttest;
-- If the length is less than zero, an ERROR is thrown.
@@ -378,7 +378,7 @@ insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
-- If the starting position is zero or less, then return from the start of the string
--- adjusting the length to be consistent with the "negative start" per SQL92.
+-- adjusting the length to be consistent with the "negative start" per SQL.
SELECT substr(f1, -1, 5) from toasttest;
-- If the length is less than zero, an ERROR is thrown.