Re: Basic SQL question and kudos - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Basic SQL question and kudos
Date
Msg-id 79278.31273.qm@web82104.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Basic SQL question and kudos  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Thanks for the start. I'll start on it.


Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life,
  otherwise we all die.

Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php


--- On Tue, 10/5/10, Craig Ringer <craig@postnewspapers.com.au> wrote:

> From: Craig Ringer <craig@postnewspapers.com.au>
> Subject: Re: [GENERAL] Basic SQL question and kudos
> To: "Dennis Gearon" <gearond@sbcglobal.net>
> Cc: pgsql-general@postgresql.org
> Date: Tuesday, October 5, 2010, 9:13 PM
> On 10/06/2010 12:31 AM, Dennis Gearon
> wrote:
> > I need to get a join across about 8 tables to only
> return rows for the MAX date in one of the tables for all
> otherwise identical return results. I am trying to get the
> most recent edit of normalized records that are composed of
> elements from all the tables. There could be 1 to 100+
> successive edits to the normalized/multi table record. The
> will be approximately 65,000 total records for now,
> 100,000,000s later.
> >
> > If I make one of the values in the select statement be
> MAX(the date), does that automatically do grouping on 'the
> date' or will I only get ONE row total returned?
>
>
> If I understand what you're proposing correctly, I don't
> think it'll work.
>
> What you need to do is use a subquery to obtain the max of
> the field of interest, and filter in your WHERE clause so
> you only return results when the selected value is the
> maximum for that field.
>
> It's hard to be more specific with a fairly general
> question like this, but if I'm understanding you right this
> is how I'd start.
>
> --
> Craig Ringer
>

pgsql-general by date:

Previous
From: Konstantin Izmailov
Date:
Subject: Re: Is there a logical reason for 25P02?
Next
From: "Vishnu S."
Date:
Subject: Re: [ADMIN] Data Not replicating