[SQL] ZIP function

2013-03-16 Thread Victor Sterpu 
Is there a function that will give the resulting zip content for a 
string?

Like SELECT zip('test data');?

Thank you.

Re: [SQL] ZIP function

2013-03-16 Thread 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



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