Re: [HACKERS] Compiling 6.4 on NetBSD-current/pc532

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