From: | Jan Wieck <janwieck(at)Yahoo(dot)com> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: man, I feel like a beginner ... |
Date: | 2000-09-13 07:58:02 |
Message-ID: | 200009130758.CAA01083@jupiter.jw.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
The Hermit Hacker wrote:
>
> someone notice anything wrong with this query? :) *slap forehead*
>
> explain
> SELECT distinct s.gid, s.created , geo_distance(pd.location, '(-90.3690233918754,38.7788148984854)')
> FROM status s, personal_data pd, relationship_wanted rw , personal_ethnicity pe , personal_religion pr , personal_bodytype pb
> WHERE s.active AND s.status != 0
> AND (s.gid = pd.gid AND pd.gender = 0)
> AND (s.gid = rw.gid AND rw.gender = 1)
> AND geo_distance( pd.location, '(-90.3690233918754,38.7788148984854)' ) <= 75
> ORDER BY geo_distance( pd.location, '(-90.3690233918754,38.7788148984854)'), s.created desc;
What's the purpose of joining it with "pb"?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2000-09-13 08:24:01 | AW: Status of new relation file naming |
Previous Message | Jan Wieck | 2000-09-13 07:42:54 | Re: PL/pgSQL does not accept none ASCII identifiers |