Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 1A6E79FA2FD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Dec 2006 12:40:35 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 04794-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Dec 2006 12:40:23 -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.189])
	by postgresql.org (Postfix) with ESMTP id 813D19FA2A7
	for <pgsql-sql@postgresql.org>; Fri, 15 Dec 2006 12:40:23 -0400 (AST)
Received: by nf-out-0910.google.com with SMTP id x4so1292943nfb
	for <pgsql-sql@postgresql.org>; Fri, 15 Dec 2006 08:40:22 -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:in-reply-to:mime-version:content-type:references;
	b=ARZ6t34+GO1tUAQQO53hKs9xYlzF0QpTKcqIEM5YISrXew7sUD2N+u5VfuzyqhZnrCu4SQKsPFHNPt/UpJTyfNPLeXU2h+rmuJwIOelWxqyJfi5lwRmyWygXQ0Tnh1NjrBkHONf6JdIzBygIM7BxabsJFrfTeJbHebZWzEjrnNA=
Received: by 10.48.210.20 with SMTP id i20mr2836616nfg.1166200822134;
	Fri, 15 Dec 2006 08:40:22 -0800 (PST)
Received: by 10.78.150.17 with HTTP; Fri, 15 Dec 2006 08:40:21 -0800 (PST)
Message-ID: <682126990612150840r409ada5y234ff3ef3ac85c5f@mail.gmail.com>
Date: Fri, 15 Dec 2006 22:10:22 +0530
From: "Ashish Ahlawat" <ahlawat.ashish@gmail.com>
To: "Markus Schaber" <schabi@logix-tt.com>
Subject: Re: join and sort on 'best match'
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20061214163659.088b7236@kingfisher.sec.intern.logix-tt.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_153179_6198842.1166200821999"
References: <457FC751.6080104@code-shop.com>
	<1166005787.6369.79.camel@localhost.localdomain>
	<682126990612140510j61d2268fq80235b02a550eccd@mail.gmail.com>
	<20061214163659.088b7236@kingfisher.sec.intern.logix-tt.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/119
X-Sequence-Number: 27075

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

Hi team

I was just asking that If table ITEM3 has all the columns then why we need
to have a join ?? even we put a sorting very easily.


*** Any way  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. 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



On 12/14/06, Markus Schaber <schabi@logix-tt.com> wrote:
>
> Hi, Ashish,
>
> "Ashish Ahlawat" <ahlawat.ashish@gmail.com> wrote:
>
> > hi pls tell me ----
> >
> > if table *Item 3 : news, nature, greenpeace, whale has all clmn y v need
> > join ??*
>
> Please try to write in English, so we can understand and answer your
> questions.
>
>
>
> Regards,
> Markus
>
> --
> Markus Schaber | Logical Tracking&Tracing International AG
> Dipl. Inf.     | Software Development GIS
>
> Fight against software patents in Europe! www.ffii.org
> www.nosoftwarepatents.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

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

<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Hi team</div>
<div>&nbsp;</div>
<div>I was just asking that If table ITEM3 has all the columns then why we need to have a join ?? even we put a sorting very easily.</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>*** Any way&nbsp; 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. 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>
<div><br><br>&nbsp;</div>
<div><span class="gmail_quote">On 12/14/06, <b class="gmail_sendername">Markus Schaber</b> &lt;<a href="mailto:schabi@logix-tt.com">schabi@logix-tt.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi, Ashish,<br><br>&quot;Ashish Ahlawat&quot; &lt;<a href="mailto:ahlawat.ashish@gmail.com">ahlawat.ashish@gmail.com
</a>&gt; wrote:<br><br>&gt; hi pls tell me ----<br>&gt;<br>&gt; if table *Item 3 : news, nature, greenpeace, whale has all clmn y v need<br>&gt; join ??*<br><br>Please try to write in English, so we can understand and answer your
<br>questions.<br><br><br><br>Regards,<br>Markus<br><br>--<br>Markus Schaber | Logical Tracking&amp;Tracing International AG<br>Dipl. Inf.&nbsp;&nbsp;&nbsp;&nbsp; | Software Development GIS<br><br>Fight against software patents in Europe! <a href="http://www.ffii.org">
www.ffii.org</a><br><a href="http://www.nosoftwarepatents.org">www.nosoftwarepatents.org</a><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 2: Don't 'kill -9' the postmaster<br></blockquote>
</div><br>

------=_Part_153179_6198842.1166200821999--