Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 008519FA111
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 19 Dec 2006 23:26:10 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 34958-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 19 Dec 2006 23:25:54 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.186])
	by postgresql.org (Postfix) with ESMTP id ECBED9F9312
	for <pgsql-sql@postgresql.org>; Tue, 19 Dec 2006 23:26:05 -0400 (AST)
Received: by nf-out-0910.google.com with SMTP id x4so2673905nfb
	for <pgsql-sql@postgresql.org>; Tue, 19 Dec 2006 19:26:04 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:mime-version:content-type;
	b=IoxhL2Ne98Y13JX0adCAvOCiwHVldwwIeetOS1YAA6fvEAEHwUG39+OIj81K/YtlV3xpTKsrU0vzeijQztS8+8ZisSLbP26RUk5jBC6wwO2/43R2lgj1QxonuvqBOCK/vBW/iM42EeOpCzrGl+rpBa5vYLD8Htj1lrPcLmWTqeo=
Received: by 10.78.158.11 with SMTP id g11mr3913554hue.1166585163908;
	Tue, 19 Dec 2006 19:26:03 -0800 (PST)
Received: by 10.78.150.17 with HTTP; Tue, 19 Dec 2006 19:25:58 -0800 (PST)
Message-ID: <682126990612191925r61a3f89av93e93af3bc8e985b@mail.gmail.com>
Date: Wed, 20 Dec 2006 08:55:58 +0530
From: "Ashish Ahlawat" <ahlawat.ashish@gmail.com>
To: Ragnar <gnari@hive.is>
Subject: Fetching BLOBs
Cc: "Dirk Griffioen" <dirk@code-shop.com>, pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_15672_26269842.1166585158785"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/151
X-Sequence-Number: 27107

------=_Part_15672_26269842.1166585158785
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi team

I have a very intersting question to all of you. Pls help me to build this
query, I want to fetch more that 70,000 BLOB from different customer
servers. the issue is there are some BOLB files with common names on all
servers. So I want merge these files into a single BLOB during  fetching
data. I am able to fetch the  BLOB data from all cust servers but
unfortunatelly it overwrite previous file.

So pls provide any simple query format for the same, assuming two table tab1
& tab 2.

Ashish  ............. INDIA

------=_Part_15672_26269842.1166585158785
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br>
<div>Hi team</div>
<div>&nbsp;</div>
<div>I have a very intersting question to all of you. Pls help me to build this query, I want to fetch more that 70,000 BLOB from different customer servers. the issue is there are some BOLB files with common names on all servers. So I want merge these files into a single BLOB&nbsp;during &nbsp;fetching data. I am able to fetch the&nbsp; BLOB data from all cust servers but unfortunatelly it overwrite previous file. 
</div>
<div>&nbsp;</div>
<div>So pls provide any simple query format&nbsp;for the same, assuming two table tab1 &amp; tab 2.</div>
<div>&nbsp;</div>
<div>Ashish&nbsp; ............. INDIA</div>

------=_Part_15672_26269842.1166585158785--