regression.diffs

application/octet-stream

Filename: regression.diffs
Type: application/octet-stream
Part: 0
Message: Re: Per-column collation, proof of concept
*** /media/linux_hhd/pgsql/releases/9.1/src/test/regress/expected/collate.out	2010-08-01 18:58:50.000000000 -0500
--- /media/linux_hhd/pgsql/releases/9.1/src/test/regress/results/collate.out	2010-08-01 19:23:14.000000000 -0500
***************
*** 6,14 ****
      a int,
      b text COLLATE "en_US"
  );
! ERROR:  collation "en_US" is not applicable to current database encoding "UTF8"
! LINE 3:     b text COLLATE "en_US"
!               ^
  CREATE TABLE collate_test_fail (
      a int,
      b text COLLATE "foo"
--- 6,12 ----
      a int,
      b text COLLATE "en_US"
  );
! ERROR:  collation "en_US" does not exist
  CREATE TABLE collate_test_fail (
      a int,
      b text COLLATE "foo"
***************
*** 25,32 ****
--- 23,34 ----
      a int,
      b text COLLATE "sv_SE.utf8"
  );
+ ERROR:  collation "sv_SE.utf8" does not exist
  INSERT INTO collate_test1 VALUES (1, 'abc'), (2, 'äbc'), (3, 'bbc');
  INSERT INTO collate_test2 SELECT * FROM collate_test1;
+ ERROR:  relation "collate_test2" does not exist
+ LINE 1: INSERT INTO collate_test2 SELECT * FROM collate_test1;
+                     ^
  SELECT * FROM collate_test1 WHERE b >= 'bbc';
   a |  b  
  ---+-----
***************
*** 34,42 ****
  (1 row)
  
  SELECT * FROM collate_test2 WHERE b >= 'bbc';
!  a |  b  
! ---+-----
!  2 | äbc
!  3 | bbc
! (2 rows)
! 
--- 36,41 ----
  (1 row)
  
  SELECT * FROM collate_test2 WHERE b >= 'bbc';
! ERROR:  relation "collate_test2" does not exist
! LINE 1: SELECT * FROM collate_test2 WHERE b >= 'bbc';
!                       ^

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