pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: operationsengineer1@yahoo.com
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Refactor Query...
Date: Mon, 12 Jun 2006 11:11:42 -0700 (PDT)
Message-ID: <20060612181142.30113.qmail@web33304.mail.mud.yahoo.com> (raw)

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...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Message-ID: <20060612181142.30113.qmail@web33304.mail.mud.yahoo.com>
Permalink:  ../20060612181142.30113.qmail@web33304.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060612181142.30113.qmail@web33304.mail.mud.yahoo.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: operationsengineer1@yahoo.com
  Subject: Re: Refactor Query...
  In-Reply-To: <20060612181142.30113.qmail@web33304.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox