From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | operationsengineer1(at)yahoo(dot)com, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Refactor Query... SOLVED |
Date: | 2006-06-12 20:19:55 |
Message-ID: | 20060612201955.96030.qmail@web33303.mail.mud.yahoo.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
--- operationsengineer1(at)yahoo(dot)com wrote:
> hi all,
>
> i'm trying to refactor this query:
>
> http://www.rafb.net/paste/results/RnkFWZ46.html
>
> i've added notes to make its function a bit more
> clear. i have trie dto refactor it to get rid of
> the
> "distinct on" function, but i've had no luck.
>
> due to all the WHERE clauses, i can't figure out how
> to do an inner join with something like this:
>
> select
> max(t_inspect_result.inspect_result_timestamp)
> as mstamp,
> t_inspect_result.inspect_id
> from t_inspect_result
> group by t_inspect_result.inspect_id
> ) AS b
>
> thanks in advance...
these queries (i have them all over my app!) are
getting complex and i'm being challenged to keep
everything in order.
this is the final result:
http://www.rafb.net/paste/results/pnvLSs30.html
here's a special thanks to all who have helped on this
and other recent query problems.
thank you!
i *rally* appreciate the chared insight and guidance.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2006-06-12 23:45:26 | Re: COPY to table with array columns (Longish) |
Previous Message | operationsengineer1 | 2006-06-12 18:11:42 | Refactor Query... |