Re: ZIP function

From: Ben Morrow <ben(at)morrow(dot)me(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: ZIP function
Date: 2013-03-17 01:36:37
Message-ID: 20130317013630.GA55434@anubis.morrow.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Quoth jasen(at)xnet(dot)co(dot)nz (Jasen Betts):
> On 2013-03-16, Victor Sterpu <victor(at)caido(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Surfing 2013-03-17 11:15:18 Efficiency Problem
Previous Message Jasen Betts 2013-03-16 23:37:07 Re: ZIP function