Re: [HACKERS] type coerce problem with lztext

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] type coerce problem with lztext
Дата
Msg-id 200002271450.JAA28342@candle.pha.pa.us
обсуждение исходный текст
Ответ на type coerce problem with lztext  (wieck@debis.com (Jan Wieck))
Ответы Re: [HACKERS] type coerce problem with lztext  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 fieldsLarger 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,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: wieck@debis.com (Jan Wieck)
Дата:
Сообщение: type coerce problem with lztext
Следующее
От: Don Baccus
Дата:
Сообщение: Re: [HACKERS] type coerce problem with lztext