*** /opt/local/pg8/pgsql/contrib/citext/expected/citext_1.out Wed Nov 5 08:33:40 2008 --- /opt/local/pg8/pgsql/contrib/citext/results/citext.out Wed Nov 5 08:34:44 2008 *************** *** 122,146 **** SELECT 'B'::citext < 'a'::text AS t; -- text wins. t --- ! t (1 row) SELECT 'B'::citext <= 'a'::text AS t; -- text wins. t --- ! t (1 row) SELECT 'a'::citext > 'B'::text AS t; -- text wins. t --- ! t (1 row) SELECT 'a'::citext >= 'B'::text AS t; -- text wins. t --- ! t (1 row) -- Test implicit casting. citext casts to varchar, but not vice-versa. --- 122,146 ---- SELECT 'B'::citext < 'a'::text AS t; -- text wins. t --- ! f (1 row) SELECT 'B'::citext <= 'a'::text AS t; -- text wins. t --- ! f (1 row) SELECT 'a'::citext > 'B'::text AS t; -- text wins. t --- ! f (1 row) SELECT 'a'::citext >= 'B'::text AS t; -- text wins. t --- ! f (1 row) -- Test implicit casting. citext casts to varchar, but not vice-versa. *************** *** 159,183 **** SELECT 'B'::citext < 'a'::varchar AS t; -- varchar wins. t --- ! t (1 row) SELECT 'B'::citext <= 'a'::varchar AS t; -- varchar wins. t --- ! t (1 row) SELECT 'a'::citext > 'B'::varchar AS t; -- varchar wins. t --- ! t (1 row) SELECT 'a'::citext >= 'B'::varchar AS t; -- varchar wins. t --- ! t (1 row) -- A couple of longer examlpes to ensure that we don't get any issues with bad --- 159,183 ---- SELECT 'B'::citext < 'a'::varchar AS t; -- varchar wins. t --- ! f (1 row) SELECT 'B'::citext <= 'a'::varchar AS t; -- varchar wins. t --- ! f (1 row) SELECT 'a'::citext > 'B'::varchar AS t; -- varchar wins. t --- ! f (1 row) SELECT 'a'::citext >= 'B'::varchar AS t; -- varchar wins. t --- ! f (1 row) -- A couple of longer examlpes to ensure that we don't get any issues with bad ======================================================================