Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.1) with ESMTP id AAA08005 for ; Fri, 23 Apr 1999 00:09:15 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id AAA20917; Fri, 23 Apr 1999 00:08:24 -0400 (EDT) To: Chris Bitmead cc: "pgsql-sql@postgresql.org" Subject: Re: [SQL] Finding the "most recent" rows In-reply-to: Your message of Fri, 23 Apr 1999 02:30:33 +0000 <371FDB49.7E7FBA35@bigfoot.com> Date: Fri, 23 Apr 1999 00:08:23 -0400 Message-ID: <20915.924840503@sss.pgh.pa.us> From: Tom Lane Chris Bitmead 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