Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)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