Re: in-date news items - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: in-date news items
Date
Msg-id Pine.LNX.4.30.0203121248130.760-100000@peter.localdomain
Whole thread Raw
In response to in-date news items  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Gary Stainburn writes:

> select ndate, nauthor, nheading
>     from news
>     order by ndate desc
>     limit 1
> *** where ndate within the last 3 months ******

ndate >= current_date - interval '3 months' and ndate <= current_date

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-sql by date:

Previous
From: "Andrew G. Hammond"
Date:
Subject: Re: SELECT FOR UPDATE
Next
From: Stephan Szabo
Date:
Subject: Re: in-date news items