*** ./expected/strings.out	Sat Jul 26 21:53:11 2003
--- ./results/strings.out	Thu Aug  7 10:58:29 2003
***************
*** 18,24 ****
  ' - next line' /* this comment is not allowed here */
  ' - third line'
  	AS "Illegal comment within continuation";
! ERROR:  syntax error at or near "' - third line'" at character 75
  --
  -- test conversions between various string types
  -- E021-10 implicit casting among the character data types
--- 18,24 ----
  ' - next line' /* this comment is not allowed here */
  ' - third line'
  	AS "Illegal comment within continuation";
! ERROR:  parse error at or near "' - third line'" at character 75
  --
  -- test conversions between various string types
  -- E021-10 implicit casting among the character data types

======================================================================

*** ./expected/create_function_1.out	Thu Aug  7 10:39:56 2003
--- ./results/create_function_1.out	Thu Aug  7 10:58:38 2003
***************
*** 54,60 ****
  DETAIL:  Actual return type is "unknown".
  CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
      AS 'not even SQL';
! ERROR:  syntax error at or near "not" at character 1
  CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
      AS 'SELECT 1, 2, 3;';
  ERROR:  return type mismatch in function declared to return integer
--- 54,60 ----
  DETAIL:  Actual return type is "unknown".
  CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
      AS 'not even SQL';
! ERROR:  parse error at or near "not" at character 1
  CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
      AS 'SELECT 1, 2, 3;';
  ERROR:  return type mismatch in function declared to return integer

======================================================================

*** ./expected/constraints.out	Thu Aug  7 10:39:56 2003
--- ./results/constraints.out	Thu Aug  7 10:58:50 2003
***************
*** 45,56 ****
  -- syntax errors
  --  test for extraneous comma
  CREATE TABLE error_tbl (i int DEFAULT (100, ));
! ERROR:  syntax error at or near "," at character 43
  --  this will fail because gram.y uses b_expr not a_expr for defaults,
  --  to avoid a shift/reduce conflict that arises from NOT NULL being
  --  part of the column definition syntax:
  CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
! ERROR:  syntax error at or near "IN" at character 43
  --  this should work, however:
  CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
  DROP TABLE error_tbl;
--- 45,56 ----
  -- syntax errors
  --  test for extraneous comma
  CREATE TABLE error_tbl (i int DEFAULT (100, ));
! ERROR:  parse error at or near "," at character 43
  --  this will fail because gram.y uses b_expr not a_expr for defaults,
  --  to avoid a shift/reduce conflict that arises from NOT NULL being
  --  part of the column definition syntax:
  CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
! ERROR:  parse error at or near "IN" at character 43
  --  this should work, however:
  CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
  DROP TABLE error_tbl;

======================================================================

*** ./expected/errors.out	Mon Jul 21 13:29:40 2003
--- ./results/errors.out	Thu Aug  7 10:59:14 2003
***************
*** 22,34 ****
   
  -- missing relation name 
  select;
! ERROR:  syntax error at or near ";" at character 7
  -- no such relation 
  select * from nonesuch;
  ERROR:  relation "nonesuch" does not exist
  -- missing target list
  select from pg_database;
! ERROR:  syntax error at or near "from" at character 8
  -- bad name in target list
  select nonesuch from pg_database;
  ERROR:  attribute "nonesuch" not found
--- 22,34 ----
   
  -- missing relation name 
  select;
! ERROR:  parse error at or near ";" at character 7
  -- no such relation 
  select * from nonesuch;
  ERROR:  relation "nonesuch" does not exist
  -- missing target list
  select from pg_database;
! ERROR:  parse error at or near "from" at character 8
  -- bad name in target list
  select nonesuch from pg_database;
  ERROR:  attribute "nonesuch" not found
***************
*** 40,46 ****
  ERROR:  attribute "nonesuch" not found
  -- bad select distinct on syntax, distinct attribute missing
  select distinct on (foobar) from pg_database;
! ERROR:  syntax error at or near "from" at character 29
  -- bad select distinct on syntax, distinct attribute not in target list
  select distinct on (foobar) * from pg_database;
  ERROR:  attribute "foobar" not found
--- 40,46 ----
  ERROR:  attribute "nonesuch" not found
  -- bad select distinct on syntax, distinct attribute missing
  select distinct on (foobar) from pg_database;
! ERROR:  parse error at or near "from" at character 29
  -- bad select distinct on syntax, distinct attribute not in target list
  select distinct on (foobar) * from pg_database;
  ERROR:  attribute "foobar" not found
***************
*** 49,55 ****
   
  -- missing relation name (this had better not wildcard!) 
  delete from;
! ERROR:  syntax error at or near ";" at character 12
  -- no such relation 
  delete from nonesuch;
  ERROR:  relation "nonesuch" does not exist
--- 49,55 ----
   
  -- missing relation name (this had better not wildcard!) 
  delete from;
! ERROR:  parse error at or near ";" at character 12
  -- no such relation 
  delete from nonesuch;
  ERROR:  relation "nonesuch" does not exist
***************
*** 58,64 ****
   
  -- missing relation name (this had better not wildcard!) 
  drop table;
! ERROR:  syntax error at or near ";" at character 11
  -- no such relation 
  drop table nonesuch;
  ERROR:  table "nonesuch" does not exist
--- 58,64 ----
   
  -- missing relation name (this had better not wildcard!) 
  drop table;
! ERROR:  parse error at or near ";" at character 11
  -- no such relation 
  drop table nonesuch;
  ERROR:  table "nonesuch" does not exist
***************
*** 68,74 ****
  -- relation renaming 
  -- missing relation name 
  alter table rename;
! ERROR:  syntax error at or near ";" at character 19
  -- no such relation 
  alter table nonesuch rename to newnonesuch;
  ERROR:  relation "nonesuch" does not exist
--- 68,74 ----
  -- relation renaming 
  -- missing relation name 
  alter table rename;
! ERROR:  parse error at or near ";" at character 19
  -- no such relation 
  alter table nonesuch rename to newnonesuch;
  ERROR:  relation "nonesuch" does not exist
***************
*** 122,131 ****
   
  -- missing index name 
  drop index;
! ERROR:  syntax error at or near ";" at character 11
  -- bad index name 
  drop index 314159;
! ERROR:  syntax error at or near "314159" at character 12
  -- no such index 
  drop index nonesuch;
  ERROR:  index "nonesuch" does not exist
--- 122,131 ----
   
  -- missing index name 
  drop index;
! ERROR:  parse error at or near ";" at character 11
  -- bad index name 
  drop index 314159;
! ERROR:  parse error at or near "314159" at character 12
  -- no such index 
  drop index nonesuch;
  ERROR:  index "nonesuch" does not exist
***************
*** 134,146 ****
   
  -- missing aggregate name 
  drop aggregate;
! ERROR:  syntax error at or near ";" at character 15
  -- missing aggregate type
  drop aggregate newcnt1;
! ERROR:  syntax error at or near ";" at character 23
  -- bad aggregate name 
  drop aggregate 314159 (int);
! ERROR:  syntax error at or near "314159" at character 16
  -- bad aggregate type
  drop aggregate newcnt (nonesuch);
  ERROR:  type "nonesuch" does not exist
--- 134,146 ----
   
  -- missing aggregate name 
  drop aggregate;
! ERROR:  parse error at or near ";" at character 15
  -- missing aggregate type
  drop aggregate newcnt1;
! ERROR:  parse error at or near ";" at character 23
  -- bad aggregate name 
  drop aggregate 314159 (int);
! ERROR:  parse error at or near "314159" at character 16
  -- bad aggregate type
  drop aggregate newcnt (nonesuch);
  ERROR:  type "nonesuch" does not exist
***************
*** 155,164 ****
   
  -- missing function name 
  drop function ();
! ERROR:  syntax error at or near "(" at character 15
  -- bad function name 
  drop function 314159();
! ERROR:  syntax error at or near "314159" at character 15
  -- no such function 
  drop function nonesuch();
  ERROR:  function nonesuch() does not exist
--- 155,164 ----
   
  -- missing function name 
  drop function ();
! ERROR:  parse error at or near "(" at character 15
  -- bad function name 
  drop function 314159();
! ERROR:  parse error at or near "314159" at character 15
  -- no such function 
  drop function nonesuch();
  ERROR:  function nonesuch() does not exist
***************
*** 167,176 ****
   
  -- missing type name 
  drop type;
! ERROR:  syntax error at or near ";" at character 10
  -- bad type name 
  drop type 314159;
! ERROR:  syntax error at or near "314159" at character 11
  -- no such type 
  drop type nonesuch;
  ERROR:  type "nonesuch" does not exist
--- 167,176 ----
   
  -- missing type name 
  drop type;
! ERROR:  parse error at or near ";" at character 10
  -- bad type name 
  drop type 314159;
! ERROR:  parse error at or near "314159" at character 11
  -- no such type 
  drop type nonesuch;
  ERROR:  type "nonesuch" does not exist
***************
*** 179,200 ****
   
  -- missing everything 
  drop operator;
! ERROR:  syntax error at or near ";" at character 14
  -- bad operator name 
  drop operator equals;
! ERROR:  syntax error at or near ";" at character 21
  -- missing type list 
  drop operator ===;
! ERROR:  syntax error at or near ";" at character 18
  -- missing parentheses 
  drop operator int4, int4;
! ERROR:  syntax error at or near "," at character 19
  -- missing operator name 
  drop operator (int4, int4);
! ERROR:  syntax error at or near "(" at character 15
  -- missing type list contents 
  drop operator === ();
! ERROR:  syntax error at or near ")" at character 20
  -- no such operator 
  drop operator === (int4);
  ERROR:  argument type missing (use NONE for unary operators)
--- 179,200 ----
   
  -- missing everything 
  drop operator;
! ERROR:  parse error at or near ";" at character 14
  -- bad operator name 
  drop operator equals;
! ERROR:  parse error at or near ";" at character 21
  -- missing type list 
  drop operator ===;
! ERROR:  parse error at or near ";" at character 18
  -- missing parentheses 
  drop operator int4, int4;
! ERROR:  parse error at or near "," at character 19
  -- missing operator name 
  drop operator (int4, int4);
! ERROR:  parse error at or near "(" at character 15
  -- missing type list contents 
  drop operator === ();
! ERROR:  parse error at or near ")" at character 20
  -- no such operator 
  drop operator === (int4);
  ERROR:  argument type missing (use NONE for unary operators)
***************
*** 206,212 ****
  ERROR:  argument type missing (use NONE for unary operators)
  -- no such type1 
  drop operator = ( , int4);
! ERROR:  syntax error at or near "," at character 19
  -- no such type1 
  drop operator = (nonesuch, int4);
  ERROR:  type nonesuch does not exist
--- 206,212 ----
  ERROR:  argument type missing (use NONE for unary operators)
  -- no such type1 
  drop operator = ( , int4);
! ERROR:  parse error at or near "," at character 19
  -- no such type1 
  drop operator = (nonesuch, int4);
  ERROR:  type nonesuch does not exist
***************
*** 215,242 ****
  ERROR:  type nonesuch does not exist
  -- no such type2 
  drop operator = (int4, );
! ERROR:  syntax error at or near ")" at character 24
  --
  -- DROP RULE
   
  -- missing rule name 
  drop rule;
! ERROR:  syntax error at or near ";" at character 10
  -- bad rule name 
  drop rule 314159;
! ERROR:  syntax error at or near "314159" at character 11
  -- no such rule 
  drop rule nonesuch on noplace;
  ERROR:  relation "noplace" does not exist
  -- bad keyword 
  drop tuple rule nonesuch;
! ERROR:  syntax error at or near "tuple" at character 6
  -- no such rule 
  drop instance rule nonesuch on noplace;
! ERROR:  syntax error at or near "instance" at character 6
  -- no such rule 
  drop rewrite rule nonesuch;
! ERROR:  syntax error at or near "rewrite" at character 6
  --
  -- Check that division-by-zero is properly caught.
  --
--- 215,242 ----
  ERROR:  type nonesuch does not exist
  -- no such type2 
  drop operator = (int4, );
! ERROR:  parse error at or near ")" at character 24
  --
  -- DROP RULE
   
  -- missing rule name 
  drop rule;
! ERROR:  parse error at or near ";" at character 10
  -- bad rule name 
  drop rule 314159;
! ERROR:  parse error at or near "314159" at character 11
  -- no such rule 
  drop rule nonesuch on noplace;
  ERROR:  relation "noplace" does not exist
  -- bad keyword 
  drop tuple rule nonesuch;
! ERROR:  parse error at or near "tuple" at character 6
  -- no such rule 
  drop instance rule nonesuch on noplace;
! ERROR:  parse error at or near "instance" at character 6
  -- no such rule 
  drop rewrite rule nonesuch;
! ERROR:  parse error at or near "rewrite" at character 6
  --
  -- Check that division-by-zero is properly caught.
  --

======================================================================