Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group