Re: [HACKERS] type coerce problem with lztext

> wieck@debis.com (Jan Wieck) writes:
> >     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?
>
> Yup, TypeCategory was the missing ingredient.  Seems to work now.
  Tnx

> Over all the rules in the regression test database, I see:
>
> regression=# select sum(length(ev_action)),sum(octet_length(ev_action)) from pg
> _rewrite;
>   sum   |  sum
> --------+-------
>  105270 | 38091
> (1 row)
>
> or about 64% compression.  Not bad...
   Amazing,  when  looking  at  the simpleness of the algorithm,   isn't it?


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