Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Finding the "most recent" rows - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Finding the "most recent" rows
Date
Msg-id 20915.924840503@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] Finding the "most recent" rows  (Chris Bitmead <chris.bitmead@bigfoot.com>)
List pgsql-sql
Tree view 
Chris Bitmead <chris.bitmead@bigfoot.com> writes:
>>>> select title, summary, time from story t where time = (select
>>>> max(s.time) from story s GROUP BY s.title);

> Why doesn't replacing "=" with "IN" produce a result? It wouldn't be the
> desired result, but I thought this was legal.

I thought so too (on both counts).  Are you saying it doesn't work?
What happens?  Which version are you using?
        regards, tom lane

pgsql-sql by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [SQL] Finding the "most recent" rows
Next
From: Brook Milligan
Date:
Subject: Re: [SQL] Finding the "most recent" rows