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: 20040830081935.A89786@megazone.bigpanda.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group