Index: expected/citext.out =================================================================== RCS file: /projects/cvsroot/pgsql/contrib/citext/expected/citext.out,v retrieving revision 1.3 diff -u -r1.3 citext.out --- expected/citext.out 5 Sep 2008 18:25:17 -0000 1.3 +++ expected/citext.out 12 Sep 2008 18:47:32 -0000 @@ -1041,6 +1041,8 @@ text text, varchar varchar, bpchar bpchar, + char char, + chr "char", name name, bytea bytea, boolean boolean, @@ -1083,6 +1085,14 @@ INSERT INTO caster (text) VALUES ('foo'::bpchar); INSERT INTO caster (bpchar) VALUES ('foo'::citext); INSERT INTO caster (citext) VALUES ('foo'::bpchar); +INSERT INTO caster (char) VALUES ('f'::text); +INSERT INTO caster (text) VALUES ('f'::char); +INSERT INTO caster (char) VALUES ('f'::citext); +INSERT INTO caster (citext) VALUES ('f'::char); +INSERT INTO caster (chr) VALUES ('f'::text); +INSERT INTO caster (text) VALUES ('f'::"char"); +INSERT INTO caster (chr) VALUES ('f'::citext); +INSERT INTO caster (citext) VALUES ('f'::"char"); INSERT INTO caster (name) VALUES ('foo'::text); INSERT INTO caster (text) VALUES ('foo'::name); INSERT INTO caster (name) VALUES ('foo'::citext); @@ -1815,6 +1825,52 @@ t (1 row) +<<<<<<< citext.out +SELECT regexp_matches('foobarbequebaz'::citext, '(BAR)(BEQUE)') = ARRAY[ 'bar', 'beque' ] AS t; + t +--- + t +(1 row) + +SELECT regexp_matches('foobarbequebaz'::citext, '(BAR)(BEQUE)'::citext) = ARRAY[ 'bar', 'beque' ] AS t; + t +--- + t +(1 row) + +SELECT regexp_matches('foobarbequebaz'::citext, '(BAR)(BEQUE)'::citext, '') = ARRAY[ 'bar', 'beque' ] AS t; + t +--- + t +(1 row) + +SELECT regexp_matches('foobarbequebaz'::citext, '(BAR)(BEQUE)', '') = ARRAY[ 'bar', 'beque' ] AS t; + t +--- + t +(1 row) + +SELECT regexp_matches('foobarbequebaz', '(BAR)(BEQUE)'::citext, '') = ARRAY[ 'bar', 'beque' ] AS t; + t +--- + t +(1 row) + +SELECT regexp_matches('foobarbequebaz'::citext, '(BAR)(BEQUE)'::citext, ''::citext) = ARRAY[ 'bar', 'beque' ] AS t; + t +--- + t +(1 row) + +-- c forces case-sensitive +SELECT regexp_matches('foobarbequebaz'::citext, '(BAR)(BEQUE)'::citext, 'c'::citext) = ARRAY[ 'bar', 'beque' ] AS "null"; + null +------ + +(1 row) + +SELECT regexp_replace('Thomas'::citext, '.[mN]a.', 'M') = 'ThM' AS t; +======= SELECT regexp_matches('foobarbequebaz'::citext, '(BAR)(BEQUE)') = ARRAY[ 'bar', 'beque' ] AS t; t --- @@ -1884,6 +1940,32 @@ -- c forces case-sensitive SELECT regexp_replace('Thomas'::citext, '.[MN]A.'::citext, 'M', 'c') = 'Thomas' AS t; +>>>>>>> 1.3 + t +--- + t +(1 row) + +SELECT regexp_replace('Thomas'::citext, '.[MN]A.', 'M') = 'ThM' AS t; + t +--- + t +(1 row) + +SELECT regexp_replace('Thomas', '.[MN]A.'::citext, 'M') = 'ThM' AS t; + t +--- + t +(1 row) + +SELECT regexp_replace('Thomas'::citext, '.[MN]A.'::citext, 'M') = 'ThM' AS t; + t +--- + t +(1 row) + +-- c forces case-sensitive +SELECT regexp_replace('Thomas'::citext, '.[MN]A.'::citext, 'M', 'c') = 'Thomas' AS t; t --- t Index: expected/citext_1.out =================================================================== RCS file: /projects/cvsroot/pgsql/contrib/citext/expected/citext_1.out,v retrieving revision 1.1 diff -u -r1.1 citext_1.out --- expected/citext_1.out 5 Sep 2008 18:25:17 -0000 1.1 +++ expected/citext_1.out 12 Sep 2008 18:47:32 -0000 @@ -1041,6 +1041,8 @@ text text, varchar varchar, bpchar bpchar, + char char, + chr "char", name name, bytea bytea, boolean boolean, @@ -1083,6 +1085,14 @@ INSERT INTO caster (text) VALUES ('foo'::bpchar); INSERT INTO caster (bpchar) VALUES ('foo'::citext); INSERT INTO caster (citext) VALUES ('foo'::bpchar); +INSERT INTO caster (char) VALUES ('f'::text); +INSERT INTO caster (text) VALUES ('f'::char); +INSERT INTO caster (char) VALUES ('f'::citext); +INSERT INTO caster (citext) VALUES ('f'::char); +INSERT INTO caster (chr) VALUES ('f'::text); +INSERT INTO caster (text) VALUES ('f'::"char"); +INSERT INTO caster (chr) VALUES ('f'::citext); +INSERT INTO caster (citext) VALUES ('f'::"char"); INSERT INTO caster (name) VALUES ('foo'::text); INSERT INTO caster (text) VALUES ('foo'::name); INSERT INTO caster (name) VALUES ('foo'::citext); Index: sql/citext.sql =================================================================== RCS file: /projects/cvsroot/pgsql/contrib/citext/sql/citext.sql,v retrieving revision 1.3 diff -u -r1.3 citext.sql --- sql/citext.sql 5 Sep 2008 18:25:17 -0000 1.3 +++ sql/citext.sql 12 Sep 2008 18:47:32 -0000 @@ -300,6 +300,8 @@ text text, varchar varchar, bpchar bpchar, + char char, + chr "char", name name, bytea bytea, boolean boolean, @@ -346,6 +348,16 @@ INSERT INTO caster (bpchar) VALUES ('foo'::citext); INSERT INTO caster (citext) VALUES ('foo'::bpchar); +INSERT INTO caster (char) VALUES ('f'::text); +INSERT INTO caster (text) VALUES ('f'::char); +INSERT INTO caster (char) VALUES ('f'::citext); +INSERT INTO caster (citext) VALUES ('f'::char); + +INSERT INTO caster (chr) VALUES ('f'::text); +INSERT INTO caster (text) VALUES ('f'::"char"); +INSERT INTO caster (chr) VALUES ('f'::citext); +INSERT INTO caster (citext) VALUES ('f'::"char"); + INSERT INTO caster (name) VALUES ('foo'::text); INSERT INTO caster (text) VALUES ('foo'::name); INSERT INTO caster (name) VALUES ('foo'::citext);