Home > mailing lists

Re: timestamp and date behaviour with '-infinity' - Mailing list pgsql-general

From	Stephan Szabo
Subject	Re: timestamp and date behaviour with '-infinity'
Date	August 30, 2004 15:26:08
Msg-id	20040830081935.A89786@megazone.bigpanda.com Whole thread Raw
In response to	timestamp and date behaviour with '-infinity' (Russell Smith <mr-russ@pws.com.au>)
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: "Matthew T. O'Connor"
Date: 30 August 2004, 14:10:25
Subject: Re: pg_autovacuum start-script

From: Rick G
Date: 30 August 2004, 15:32:36
Subject: Re: monitor+keyboard+mouse together

Re: timestamp and date behaviour with '-infinity' - Mailing list pgsql-general

Previous

Next