Postgres Pro
Downloads
Home   >   mailing lists

Re: bug: select date 'infinity' gives error - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: bug: select date 'infinity' gives error
Date
Msg-id 3DDC84FF.1020107@mega-bucks.co.jp
Whole thread Raw
In response to bug: select date 'infinity' gives error  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tree view 
Tom Lane wrote:
 >
 >This is a documentation bug.

Shucks ...

Is there a way to get an equivalent to infinity for a date?

Also, what is the correct way to typecast? I have seen this version
"x::data_type" and also while researching infinity for dates
"timestamp'infinity'".

Is timstamp'infinity' type-casting, or a function call, or ...?

Thanks,

Jc

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: bug: select date 'infinity' gives error
Next
From: Oliver Elphick
Date:
Subject: Re: &main::execute undefined?