From: Ashish Ahlawat <ahlawat.ashish@gmail.com>
To: Markus Schaber <schabi@logix-tt.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: join and sort on 'best match'
Date: Fri, 15 Dec 2006 22:10:22 +0530
Message-ID: <682126990612150840r409ada5y234ff3ef3ac85c5f@mail.gmail.com> (raw)
In-Reply-To: <20061214163659.088b7236@kingfisher.sec.intern.logix-tt.com>
References: <457FC751.6080104@code-shop.com>
<1166005787.6369.79.camel@localhost.localdomain>
<682126990612140510j61d2268fq80235b02a550eccd@mail.gmail.com>
<20061214163659.088b7236@kingfisher.sec.intern.logix-tt.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ahlawat.ashish@gmail.com, schabi@logix-tt.com
Subject: Re: join and sort on 'best match'
In-Reply-To: <682126990612150840r409ada5y234ff3ef3ac85c5f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox