Re: fetch first rows of grouped data

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: Claudia Kosny <ckosny(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: fetch first rows of grouped data
Date: 2007-08-28 13:13:19
Message-ID: 20070828131319.GA1229@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Aug 28, 2007 at 08:00:42AM -0500, Michael Glaesemann wrote:
> >you can try to use "distinct on".
> I considered that as well, but couldn't think of a way to return more

you're right and i was wrong. i simply missed the word "two" in original
question. sorry.

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-08-28 13:26:04 Re: Database normalization
Previous Message Asko Oja 2007-08-28 13:00:55 Re: Database normalization