From: Aaron Bono <aaron.bono@aranya.com>
To: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Fwd: Stalled post to pgsql-sql
Date: Thu, 1 Jun 2006 13:42:29 -0500
Message-ID: <bf05e51c0606011142i1e262a37m2bfe5baef59a476a@mail.gmail.com> (raw)
In-Reply-To: <54223ebf21d014c0641a385526e8ab37330e465c@postgresql.org>
References: <54223ebf21d014c0641a385526e8ab37330e465c@postgresql.org>
I think this approach will only work if each broadcast_id has the same
maximum date_sent value. You really need to do the group by in a
sub-query to bring the broadcast_id together with the max date_sent.
-Aaron Bono
On 6/1/06, Yasir Malik <ymalik@cs.stevens.edu> wrote:
> > What I would like to do is simply get the last date_sent and it's
> > status for every broadcast. I can't do a GROUP BY because I can't put
> > an aggregate on the status column.
> >
> > SELECT MAX(date_sent), status
> > FROM broadcast_history
> > GROUP BY broadcast_id
> >
> You could try the following:
> select status
> from broadcast_history bh
> where bh.date_sent =
> (select max(bh2.date_sent)
> from broadcast_history bh2);
>
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: aaron.bono@aranya.com
Subject: Re: Fwd: Stalled post to pgsql-sql
In-Reply-To: <bf05e51c0606011142i1e262a37m2bfe5baef59a476a@mail.gmail.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