Picking the first of an order in an aggregate query - Mailing list pgsql-general

From Robert James
Subject Picking the first of an order in an aggregate query
Date
Msg-id CAGYyBgi7Jf-=SHDQwnDC6YO+dp_f+sNL6=Ax=5wAwgFhLRhG9w@mail.gmail.com
Whole thread Raw
Responses Re: Picking the first of an order in an aggregate query  (Jack Christensen <jack@jackchristensen.com>)
List pgsql-general
I have a query

  SELECT grouping_field, MIN(field_a), MIN(field_b)
  FROM ...
  GROUP BY grouping_field

But, instead of picking the MIN field_a and MIN field_b, I'd like to
pick field_a and field_b from the first record, according to an order
I'll specify.  In pseudo-SQL, it would be something like this:

  SELECT grouping_field, FIRST(field_a), FIRST(field_b)
  FROM ...
  ORDER BY field_c DESC, field_d ASC, myfunc(field_e) ASC
  GROUP BY grouping_field

How can I do that with Postgres?


pgsql-general by date:

Previous
From: Philipp Kraus
Date:
Subject: Re: rights for schema
Next
From: Jack Christensen
Date:
Subject: Re: Picking the first of an order in an aggregate query