From victor@caido.ro Sat Mar  16 19:50:47 2013
Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37197=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UGx7v-00084I-BS
	for pgsql-sql@arkaria.postgresql.org; Sat, 16 Mar 2013 19:50:47 +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+M37197=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UGx7u-0007ol-MO
	for pgsql-sql@arkaria.postgresql.org; Sat, 16 Mar 2013 19:50:46 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <victor@caido.ro>) id 1UGx7t-0007of-Ov
	for pgsql-sql@postgresql.org; Sat, 16 Mar 2013 19:50:45 +0000
Received: from ppp248107867.ambra.ro ([86.107.248.7] helo=caido.ro)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <victor@caido.ro>) id 1UGx7p-0000RU-4r
	for pgsql-sql@postgresql.org; Sat, 16 Mar 2013 19:50:45 +0000
Received: from localhost (localhost [127.0.0.1])
	by caido.ro (Postfix) with ESMTP id 367CA141215
	for <pgsql-sql@postgresql.org>; Sat, 16 Mar 2013 21:50:37 +0200 (EET)
X-Virus-Scanned: amavisd-new at caido.ro
Received: from caido.ro ([127.0.0.1])
	by localhost (caido.ro [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id ekhp6mteBQyE for <pgsql-sql@postgresql.org>;
	Sat, 16 Mar 2013 21:50:36 +0200 (EET)
Received: from localhost (localhost [127.0.0.1])
	by caido.ro (Postfix) with ESMTP id 8272E14123C
	for <pgsql-sql@postgresql.org>; Sat, 16 Mar 2013 21:50:36 +0200 (EET)
X-Amavis-Modified: Mail body modified (using disclaimer) - caido.ro
X-Virus-Scanned: amavisd-new at caido.ro
Received: from caido.ro ([127.0.0.1])
	by localhost (caido.ro [127.0.0.1]) (amavisd-new, port 10026)
	with ESMTP id suqGZgnOeNJj for <pgsql-sql@postgresql.org>;
	Sat, 16 Mar 2013 21:50:35 +0200 (EET)
Received: from [127.0.0.1] (unknown [89.43.152.14])
	by caido.ro (Postfix) with ESMTPSA id 2FC33141215
	for <pgsql-sql@postgresql.org>; Sat, 16 Mar 2013 21:50:35 +0200 (EET)
From: "Victor Sterpu" <victor@caido.ro>
To: pgsql-sql@postgresql.org
Subject: ZIP function
Date: Sat, 16 Mar 2013 19:50:31 +0000
Content-Type: multipart/alternative;
	boundary="------=_MBF521B7A8-BC31-4E93-BC62-8C86007F2089"
Message-Id: <em04f8489f-a226-4595-8bc0-5d552b2bdf8a@victor-pc>
Mime-Version: 1.0
Reply-To: "Victor Sterpu" <victor@caido.ro>
User-Agent: eM_Client/5.0.17595.0
X-Pg-Spam-Score: 0.8 (/)
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


--------=_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');?

Thank you.

--------=_MBF521B7A8-BC31-4E93-BC62-8C86007F2089
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=utf-8

<HTML><HEAD>
<STYLE id=3DeMClientCss>
blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px;=
 padding-right:0px; border-left: 1px solid #000000 }
.plain pre, .plain tt { font-family: monospace; font-size: 100%; font-weigh=
t: normal; font-style: normal; }
body {font-family: Tahoma;font-size: 12pt;}
.plain pre, .plain tt {font-family: Tahoma;font-size: 12pt;}</STYLE>
</HEAD>
<BODY>
<DIV>Is there a function that will give the resulting&nbsp;zip content for=
 a string?</DIV>
<DIV>Like SELECT zip('test data');?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thank you.</DIV>
<br>=
<html><body><p><font FACE=3DARIAL size=3D1 color=3DDARKGREEN><I><B>DISCLAIMER</B>: <BR>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.</I></font></p></body></html>
<br>=
</BODY></HTML>
--------=_MBF521B7A8-BC31-4E93-BC62-8C86007F2089--





From jasen@xnet.co.nz Sun Mar  17 00:01:39 2013
Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37198=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UH12h-0008F5-OY
	for pgsql-sql@arkaria.postgresql.org; Sun, 17 Mar 2013 00:01:39 +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+M37198=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UH12h-0001QG-4w
	for pgsql-sql@arkaria.postgresql.org; Sun, 17 Mar 2013 00:01:39 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1UH12f-0001Q8-5z
	for pgsql-sql@postgresql.org; Sun, 17 Mar 2013 00:01:37 +0000
Received: from plane.gmane.org ([80.91.229.3])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1UH12b-000550-Op
	for pgsql-sql@postgresql.org; Sun, 17 Mar 2013 00:01:36 +0000
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1UH12u-0005vr-CG
	for pgsql-sql@postgresql.org; Sun, 17 Mar 2013 01:01:52 +0100
Received: from ip-118-90-95-71.xdsl.xnet.co.nz ([118.90.95.71])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Sun, 17 Mar 2013 01:01:52 +0100
Received: from jasen by ip-118-90-95-71.xdsl.xnet.co.nz with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Sun, 17 Mar 2013 01:01:52 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Jasen Betts <jasen@xnet.co.nz>
Subject: Re: ZIP function
Date: 16 Mar 2013 23:37:07 GMT
Organization: Dis (not Dat) Organisation
Lines: 16
Message-ID: <ki2vn3$m0q$1@gonzo.reversiblemaps.ath.cx>
References: <em04f8489f-a226-4595-8bc0-5d552b2bdf8a@victor-pc>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: ip-118-90-95-71.xdsl.xnet.co.nz
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a
	+M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;
	(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6
	{T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;
	8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent: slrn/pre1.0.0-18 (Linux)
X-Pg-Spam-Score: -4.3 (----)
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

On 2013-03-16, Victor Sterpu <victor@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 (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



From ben@morrow.me.uk Sun Mar  17 01:36:52 2013
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