diff options
Diffstat (limited to 'src/test/regress')
-rw-r--r-- | src/test/regress/expected/boolean.out | 2 | ||||
-rw-r--r-- | src/test/regress/expected/case.out | 2 | ||||
-rw-r--r-- | src/test/regress/expected/strings.out | 8 | ||||
-rw-r--r-- | src/test/regress/input/constraints.source | 2 | ||||
-rw-r--r-- | src/test/regress/output/constraints.source | 2 | ||||
-rw-r--r-- | src/test/regress/sql/boolean.sql | 2 | ||||
-rw-r--r-- | src/test/regress/sql/case.sql | 2 | ||||
-rw-r--r-- | src/test/regress/sql/strings.sql | 8 |
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. |