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

Re: plperl functions -- can they call each other?

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: plperl functions -- can they call each other?
Date: 2003-01-31 23:21:30
Message-ID: 20030131232130.GB1464@mail.serensoft.com (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, Jan 29, 2003 at 03:50:46PM -0500, Jean-Luc Lachance wrote:
> Another Y2K bug in the making...
> 
> Leap year if:
> ((y % 4 == 0) and ( y % 100 != 0)) or ( y % 400 == 0)

oh sure, if you subscribe to that nasty, tired, old, worn-out
gregorian calendar prototype... :) [good eye.]

[plperl CODE=snippet FEEDBACK=welcome]
>       # 28 days valid for ANY month:
>       ($d <= 28)
>       or
>       # 29 days ok if !feb -- or in a leap year
>       ($d <= 29 and ( $m != 2 or $y % 4 == 0 ))
>       or
>       # 30 days good if not february
>       ($d <= 30 and $m != 2)
>       or
>       # 31 days ok for jan/mar/may/jul/aug/oct/dec
>       ($d <= 31 and $m =~ /^(1|3|5|7|8|10|12)$/)
[/plperl]

first discrepancy, since 1901, would be 29 feb 2100. (and the
whole y%400 y!%100 y%4 paradigm will need revision anyway
somewhere around 2800 or so, depending on your parameters).
lifetime of this project is unlikely to be a decade, certainly
not a century. not worth the excess computing cycles, methinks,
certainly not for my situation.

still, you win the prize for first eyeball. :)

-- 
There are 10 kinds of people:
ones that get binary, and ones that don't.
 
will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
 
Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !

In response to

pgsql-general by date

Next:From: Dmitry TkachDate: 2003-01-31 23:23:47
Subject: Re: Query performance PLEASE HELP
Previous:From: Luis MagaƱaDate: 2003-01-31 23:13:30
Subject: Name of days and months

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