Skip site navigation (1) Skip section navigation (2)

Re: join and sort on 'best match'

From: "Ashish Ahlawat" <ahlawat(dot)ashish(at)gmail(dot)com>
To: "Markus Schaber" <schabi(at)logix-tt(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: join and sort on 'best match'
Date: 2006-12-15 16:40:22
Message-ID: 682126990612150840r409ada5y234ff3ef3ac85c5f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)logix-tt(dot)com> wrote:
>
> Hi, Ashish,
>
> "Ashish Ahlawat" <ahlawat(dot)ashish(at)gmail(dot)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
>

In response to

Responses

pgsql-sql by date

Next:From: RagnarDate: 2006-12-15 19:46:47
Subject: Re: join and sort on 'best match'
Previous:From: Richard Broersma JrDate: 2006-12-15 16:21:08
Subject: Re: Need to subtract values between previous and current row

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group