Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37199=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UH2Wp-0007xT-Kg
	for pgsql-sql@arkaria.postgresql.org; Sun, 17 Mar 2013 01:36:52 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37199=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UH2Wo-0005TD-9D
	for pgsql-sql@arkaria.postgresql.org; Sun, 17 Mar 2013 01:36:50 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <mauzo@anubis.morrow.me.uk>) id 1UH2Wn-0005T7-0P
	for pgsql-sql@postgresql.org; Sun, 17 Mar 2013 01:36:49 +0000
Received: from isis.morrow.me.uk ([204.109.63.142])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <mauzo@anubis.morrow.me.uk>) id 1UH2Wi-0005mU-M7
	for pgsql-sql@postgresql.org; Sun, 17 Mar 2013 01:36:48 +0000
Received: from anubis.morrow.me.uk
	(host86-177-98-144.range86-177.btcentralplus.com [86.177.98.144])
	(Authenticated sender: mauzo)
	by isis.morrow.me.uk (Postfix) with ESMTPSA id 502C945062
	for <pgsql-sql@postgresql.org>; Sun, 17 Mar 2013 01:36:41 +0000 (UTC)
DKIM-Filter: OpenDKIM Filter v2.7.4 isis.morrow.me.uk 502C945062
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=morrow.me.uk;
	s=dkim201101; t=1363484202;
	bh=3p3fjXGkWwpTPR5jv93eTmt8sWxPlZqF/Fpha+V/uvo=;
	h=Date:From:To:Subject:References:In-Reply-To;
	b=wI7m0g6Vwd5/xJuFbUUvdSPvISbxNDdY466qr6BcasHMxY3dw8YhbqEZLDH7OB8OS
	Yvwu9O9NbhqEdg/x7aI7sRS8+U/d5hT/NSgnJBeroioPRpMUHhmjrahswjWIQcLVPs
	arZMhsoO5CsMjuZdB26BnoEXmIk3KGxL7OqZFez0=
X-Virus-Status: Clean
X-Virus-Scanned: clamav-milter 0.97.6 at isis.morrow.me.uk
Received: by anubis.morrow.me.uk (Postfix, from userid 5001)
	id 016E89D39; Sun, 17 Mar 2013 01:36:37 +0000 (GMT)
Date: Sun, 17 Mar 2013 01:36:37 +0000
From: Ben Morrow <ben@morrow.me.uk>
To: pgsql-sql@postgresql.org
Subject: Re: ZIP function
Message-ID: <20130317013630.GA55434@anubis.morrow.me.uk>
References: <em04f8489f-a226-4595-8bc0-5d552b2bdf8a@victor-pc>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <ki2vn3$m0q$1@gonzo.reversiblemaps.ath.cx>
X-Newsgroups: pgsql.sql
Organization: morrow.me.uk
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -4.4 (----)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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



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