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

Re: Doubt about join queries

From: jc_mich <juan(dot)michaca(at)paasel(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Doubt about join queries
Date: 2009-04-21 17:03:53
Message-ID: 23160612.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-general
Thanks a lot! It works as good as I wish

Best regards.


Michael Nolan wrote:
> 
> On Tue, Apr 21, 2009 at 12:04 PM, jc_mich <juan(dot)michaca(at)paasel(dot)com> wrote:
> 
>>
>> The problem is not the formula, the problem is the join. I've summarized
>> it
>> because is a large formula and I've got right results
>>
>>
> You're quite correct that the problem is the join, because neither of the
> examples you gave have any code to limit the number of store records
> returned.
> 
> You may need to include something like the following code fragment.  (I'm
> using a 'distance' formula as a proxy for the latitude/longitude formula.)
> 
> where store_no = (select store_no from store order by
> distance(store,customer) limit 1)
> --
> Mike Nolan
> 
> 

-- 
View this message in context: http://www.nabble.com/Doubt-about-join-queries-tp23142980p23160612.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2009-04-21 17:13:38
Subject: Re: trouble with to_char('L')
Previous:From: Chris WorleyDate: 2009-04-21 16:52:12
Subject: COPY 'invalid byte sequence for encoding "UTF8": 0xff'

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