Re: ZIP function - Mailing list pgsql-sql

From Ben Morrow
Subject Re: ZIP function
Date
Msg-id 20130317013630.GA55434@anubis.morrow.me.uk
Whole thread Raw
In response to Re: ZIP function  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-sql
Quoth jasen@xnet.co.nz (Jasen Betts):
> On 2013-03-16, Victor Sterpu <victor@caido.ro> wrote:
> >
> > Is there a function that will give the resulting zip content for a=20
> > string?
> > Like SELECT zip('test data');?
> 
> no. you could write one that calls gzip in one of the untrusted
> languages.  or in C you could call zlib.

You can call Compress::Zlib or Archive::Zip (depending on which sort of
'zip' you mean) from (trusted) PL/Perl, provided you load the modules
from plperl.on_init.

Ben




pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: ZIP function
Next
From: Surfing
Date:
Subject: Efficiency Problem