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: (view raw, whole thread or download thread mbox)
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:
Sent from the PostgreSQL - general mailing list archive at

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-2018 The PostgreSQL Global Development Group