[Please don't top post as it makes the discussion more difficult to
On Oct 31, 2007, at 12:40 , Wright, George wrote:
> In the Bruce Momjian PostGreSQL Introduction and Concepts book:
Yeah, that's getting pretty long in the tooth. (And by the way, it's
PostgreSQL. No cap G)
> In the temporal section it mentions
> Function Returns
> isfinite(col) BOOLEAN indicating whether col is a valid date.
I'd argue that this has always been wrong, but my PostgreSQL
knowledge doesn't extend quite that far back.
> Is there a calendar validation routine in PostGreSQL? I didn't see one
> in the \df listing.
Depends on what you mean by calendar validation. For the specific
case you've been interested in, I doubt it, though you could probably
cobble one together using a procedural language. Maybe PL/perlu and
some Perl libraries would help you out.
grzm seespotcode net
In response to
pgsql-novice by date
|Next:||From: niccguard-dev||Date: 2007-10-31 19:34:08|
|Subject: What data type best used for money|
|Previous:||From: Wright, George||Date: 2007-10-31 17:40:38|
|Subject: Re: timestamp problem|