Jon Buller wrote:
>
> For some reason which I haven't figured out yet, it thinks the
> following:
>
> template1=> select ('epoch'::datetime) as ZeroSecs;
> zerosecs
> ----------------------------
> Fri Dec 31 18:00:00 1999 CST
> (1 row)
>
> template1=> select ('current'::datetime) as ZeroSecs;
> zerosecs
> ----------------------------
> Fri Dec 31 18:00:00 1999 CST
> (1 row)
>
> template1=> select ('now'::datetime) as ZeroSecs;
> zerosecs
> ----------------------------
> Sun Sep 13 19:05:43 1998 CDT
> (1 row)
So I thought I would try it and:
template1=> select ('epoch'::datetime) as ZeroSecs;
zerosecs
--------
epoch
(1 row)
template1=> select ('current'::datetime) as ZeroSecs;
zerosecs
--------
current
(1 row)
template1=> select ('now'::datetime) as ZeroSecs;
zerosecs
----------------------------
Mon Sep 14 11:01:44 1998 BST
(1 row)
?!
Cheers,
Patrick
PS
#define DBL_MAX 1.7976931348623157E+308
#define DBL_MIN 2.2250738585072014E-308
and are OK in a program - NetBSD/i386, postgresql-current