pgsql: Adjust citext to make use of the new ability to declare its type

Log Message:
-----------
Adjust citext to make use of the new ability to declare its type category:
by putting it into the standard string category, we cause casts from citext
to text to be recognized as "preferred" casts.  This eliminates the need
for creation of alias functions and operators that only serve to prevent
ambiguous-function errors; get rid of the ones that were in the original
commit.

Modified Files:
--------------
    pgsql/contrib/citext:
        citext.sql.in (r1.1 -> r1.2)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/citext/citext.sql.in?r1=1.1&r2=1.2)
        uninstall_citext.sql (r1.1 -> r1.2)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/citext/uninstall_citext.sql?r1=1.1&r2=1.2)