Re: TODAY! Synchronized Scanning with Jeff Davis

From: merlyn(at)stonehenge(dot)com (Randal L(dot) Schwartz)
To: Selena Deckelmann <sdeckelmann(at)chrisking(dot)com>
Cc: Postgresql PDX_Users <pdxpug(at)postgresql(dot)org>
Subject: Re: TODAY! Synchronized Scanning with Jeff Davis
Date: 2007-08-16 18:58:05
Message-ID: 86fy2jcnnm.fsf@blue.stonehenge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

>>>>> "Randal" == Randal L Schwartz <merlyn(at)stonehenge(dot)com> writes:

Randal> That could either mean "meets the third Thursday of every month" or
Randal> "meets every three weeks, on a Thursday". I *think* you mean the
Randal> first, so you might want to update that. Better yet, provide a Pg
Randal> function that is true on that day. :)

SELECT
EXTRACT(DOW FROM now()) = 4
AND EXTRACT(DAY FROM now()) BETWEEN 15 AND 21
AS "Meeting tonight?";

:-)

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

In response to

Responses

Browse pdxpug by date

  From Date Subject
Next Message Thomas Keller 2007-08-16 22:29:17 Re: TODAY! Synchronized Scanning with Jeff Davis
Previous Message Randal L. Schwartz 2007-08-16 18:51:18 Re: TODAY! Synchronized Scanning with Jeff Davis