[Please don't top post as it makes the discussion more difficult to
follow.]
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.
Michael Glaesemann
grzm seespotcode net