Re: timestamp and date behaviour with '-infinity'

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp and date behaviour with '-infinity'
Date: 2004-08-30 15:26:06
Message-ID: 20040830081935.A89786@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 30 Aug 2004, Russell Smith wrote:

> Timestamps support infinity. However if appears dates do not.
>
> When timestamps are cast to dates, there is no output. Is this an acceptable option or not?

It looks to me that it turns into a NULL date. I'm not sure why it's
doing that rather than an error, though.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-30 15:33:08 Re: timestamp and date behaviour with '-infinity'
Previous Message Matthew T. O'Connor 2004-08-30 14:10:16 Re: pg_autovacuum start-script