Re: bug: select date 'infinity' gives error

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: bug: select date 'infinity' gives error
Date: 2002-11-21 07:02:23
Message-ID: 3DDC84FF.1020107@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-11-21 07:40:43 Re: &main::execute undefined?
Previous Message Jean-Christian Imbeault 2002-11-21 07:01:12 Re: bug: select date 'infinity' gives error