From: | prlw1(at)cam(dot)ac(dot)uk (Patrick Welche) |
---|---|
To: | jonb(at)metronet(dot)com (Jon Buller) |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Compiling 6.4 on NetBSD-current/pc532 |
Date: | 1998-09-14 10:05:41 |
Message-ID: | E0zIVVt-0002Ws-00@taurus.cus.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-09-14 13:32:55 | Re: [HACKERS] Compiling 6.4 on NetBSD-current/pc532 |
Previous Message | Frank Ridderbusch | 1998-09-14 09:37:19 | Re: [HACKERS] Also on SVR4 (Compiling 6.4 on NetBSD-current/pc532) |