ZIP function

[Victor Sterpu]

Is there a function that will give the resulting zip content for a string?

Like SELECT zip('test data');?

 

Thank you.

DISCLAIMER:
Acest mesaj de posta electronica si documentele aferente sunt confidentiale. Este interzisa distribuirea, dezvaluirea sau orice alt mod de utilizare a lor. Daca nu sunteti destinatarul acestui mesaj, este interzis sa actionati in baza acestor informatii. Citirea, copierea, distribuirea, dezvaluirea sau utilizarea in alt mod a informatiei continute in acest mesaj constituie o incalcare a legii. Daca ati primit mesajul din greseala, va rugam sa il distrugeti, anuntand expeditorul de eroarea comisa. Intrucat nu poate fi garantat faptul ca posta electronica este un mod sigur si lipsit de erori de transmitere a informatiilor, este responsabilitatea dvs. sa va asigurati ca mesajul (inclusiv documentele alaturate lui) este validat si autorizat spre a fi utilizat in mediul dvs.

[Jasen Betts]

On 2013-03-16, Victor Sterpu <vic...@caido.ro> wrote:
>
> --------=_MBF521B7A8-BC31-4E93-BC62-8C86007F2089
> Content-Transfer-Encoding: quoted-printable
> Content-Type: text/plain; format=flowed; charset=utf-8
>
> 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.


--
⚂⚃ 100% natural



--
Sent via pgsql-sql mailing list (pgsq...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

[Ben Morrow]

Quoth ja...@xnet.co.nz (Jasen Betts):

> On 2013-03-16, Victor Sterpu <vic...@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