Re: [HACKERS] type coerce problem with lztext
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Jan Wieck <wieck@debis.com>
Cc: PostgreSQL HACKERS <pgsql-hackers@postgreSQL.org>
Date: 2000-02-27T14:50:45Z
Lists: pgsql-hackers
> 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? Added to Features: New lztext data type for compressed text fields Larger views/rules supported -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026