in-date news items - Mailing list pgsql-sql

From Gary Stainburn
Subject in-date news items
Date
Msg-id E16klCx-0005A6-00@stan.ringways.co.uk
Whole thread Raw
Responses Re: in-date news items
Re: in-date news items
Re: in-date news items
List pgsql-sql
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 ******
;
-- 
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     


pgsql-sql by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: GRANT problem ?
Next
From: Gary Stainburn
Date:
Subject: Re: in-date news items