Received: from stan.ringways.co.uk (unknown [213.38.87.130]) by postgresql.org (Postfix) with ESMTP id D30A147648E for ; Tue, 12 Mar 2002 12:20:47 -0500 (EST) Received: from gary.ringways.co.uk ([10.1.1.2] helo=there) by stan.ringways.co.uk with smtp (Exim 3.33 #2) id 16kpvs-0007Mm-00; Tue, 12 Mar 2002 17:19:28 +0000 Content-Type: text/plain; charset="iso-8859-1" From: Gary Stainburn Organization: Ringways Garages Ltd To: Ian Barwick , "pgsql-sql" Subject: Re: in-date news items Date: Tue, 12 Mar 2002 17:19:43 +0000 X-Mailer: KMail [version 1.3.2] References: <02031214251401.06708@redgrave> In-Reply-To: <02031214251401.06708@redgrave> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: X-Archive-Number: 200203/118 X-Sequence-Number: 6999 On Tuesday 12 March 2002 1:25 pm, Ian Barwick wrote: > On Tuesday 12 March 2002 13:17, Gary Stainburn wrote: > > Hi all, > > > > I'm trying to use a select to get the latest item of news, provided that > > it's within the last X days. What do I need to add to the where clause > > for the select statement below: > > > > select ndate, nauthor, nheading > > from news > > order by ndate desc > > limit 1 > > *** where ndate within the last 3 months ****** > > ; > > something like: > > where ndate > current_timestamp - interval '3 months' > > more on the subject here: > > http://techdocs.postgresql.org/techdocs/faqdatesintervals.php > > Ian Barwick Thanks for that Ian, worked a treat. However, can someone tell me why select n.ntimestamp, n.nmid from news n where n.ntimestamp > current_time - interval '5 minutes'; works while select n.ntimestamp, n.nmid, m.mfname, m.mlname from news n, members m order by ntimestamp desc limit 1 where (n.nmid = m.mid) and (n.ntimestamp > current_time - interval '5 minutes'); has a parse error at or near "where" -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000