type coerce problem with lztext

Well,

    LZTEXT  is there again, and pg_rewrite uses it for action and
    qual strings. This is what it tells:

    pgsql=# select rulename, length(ev_action), octet_length(ev_action)
    pgsql-#   from pg_rewrite;
        rulename    | length | octet_length
    ----------------+--------+--------------
     _RETpg_user    |   3043 |          855
     _RETpg_rules   |   3074 |         1139
     _RETpg_views   |   4261 |         1252
     _RETpg_tables  |   5187 |         1338
     _RETpg_indexes |   3525 |         1122
    (5 rows)

    Yes, the 3043 bytes long rule action string got stored in 855
    bytes  in  pg_rewrite.  That's 71.9% compression rate on this
    attempt!

    There are functions text(lztext) and  lztext(text)  too,  but
    the  system  is  unable  to  find an operator if one compares
    text=lztext in a query. IIRC, creating a  function  named  as
    the target type and taking the source type is what made auto-
    type-conversion work - so what am I missing here?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #