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
rateon 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
whatmade 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) #