Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id A6CC79FA364
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat, 16 Dec 2006 07:14:33 -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 98033-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat, 16 Dec 2006 07:14:09 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168])
	by postgresql.org (Postfix) with ESMTP id 2C3BB9F9F08
	for <pgsql-sql@postgresql.org>; Sat, 16 Dec 2006 07:14:12 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so1055428ugf
	for <pgsql-sql@postgresql.org>; Sat, 16 Dec 2006 03:14:12 -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=bMQaRMM/cl3t43AqLNBqwLCTP9o6GtqwEEGyrmIpx8RpWoxF8WEfg4tbdWJzasVuaYZRuWQP8+8xb785Jo3yLo0KaUqJE+yEdmlmpfwhMKs6AcNLbsq+J+9kCs8RMe7XZxOwSMEDJs2SMXpkKK4SxdFmZ8HPw+omVZMbbK+vFN0=
Received: by 10.78.171.13 with SMTP id t13mr262485hue.1166267652029;
	Sat, 16 Dec 2006 03:14:12 -0800 (PST)
Received: by 10.78.150.17 with HTTP; Sat, 16 Dec 2006 03:14:11 -0800 (PST)
Message-ID: <682126990612160314r287ef6cmd0353871fb4e7ff4@mail.gmail.com>
Date: Sat, 16 Dec 2006 16:44:11 +0530
From: "Ashish Ahlawat" <ahlawat.ashish@gmail.com>
To: Ragnar <gnari@hive.is>
Subject: fetching & Merging BLOB
Cc: "Markus Schaber" <schabi@logix-tt.com>, pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_162426_3104946.1166267651982"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/126
X-Sequence-Number: 27082

------=_Part_162426_3104946.1166267651982
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. 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. Although I am able to fetch the
BLOB data from all cust servers but unfortunatelly it overwrite previous
same name file instead of merging.

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

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

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

<div>&nbsp;Hi team</div>
<div>&nbsp;</div>
<div>I have a very intersting question to all of you. 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. Although I am able to fetch the&nbsp; BLOB data from all cust servers but unfortunatelly it overwrite previous same name file instead of merging. 
</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_162426_3104946.1166267651982--