Yearly date comparison?

From: Nick <nboutelier(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Yearly date comparison?
Date: 2012-02-29 04:14:30
Message-ID: a48f5b10-216e-4508-bfa6-2a1e4734d3a9@p13g2000yqd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is the best way to find an event with a yearly occurrence?

CREATE TABLE events (
start_date DATE,
end_date DATE,
recurring TEXT
);
INSERT INTO events (start_date, end_date, recurring) VALUES
('2010-02-28','2010-03-01','yearly');

SELECT * FROM events WHERE (start_date+'2 YEARS'::INTERVAL) >= NOW()
AND (end_date+'2 YEARS'::INTERVAL) < NOW();

Since I may not know how many years back the start/end_date is, is
there a way to just ignore the year or make it the current year,
without killing performance?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hamann.w 2012-02-29 04:44:57 Re: what Linux to run
Previous Message Fujii Masao 2012-02-29 04:02:55 Re: synchronous replication: blocking commit on the master