Re: [SQL] Finding the "most recent" rows

Tom Lane wrote:
> 
> 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?

httpd=> select title, summary, time from story t where time IN (select
max(s.time) from story s GROUP BY s.title);
ERROR:  parser: Subselect has too many or too few fields.

I'm using postgresql-snap-990329.tgz