Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group