On 18/05/2011 4:02 AM, James B. Byrne wrote:
On Fri, May 13, 2011 13:04, James B. Byrne wrote:
I have opened an issue for this with the ActiveRecord folks.
https://github.com/rails/rails/issues/544
This has been addressed by the AR team and is committed to master.
+-Infinity support for da
On Fri, May 13, 2011 13:04, James B. Byrne wrote:
>
> I have opened an issue for this with the ActiveRecord folks.
>
> https://github.com/rails/rails/issues/544
>
This has been addressed by the AR team and is committed to master.
+-Infinity support for dates is slated for general release with
RoR
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Tom Lane
...
>
> "Ken Winter" writes:
> > The documentation at
> > http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems
> to
> > say that the spe
Ken Winter wrote:
The documentation at
http://www.postgresql.org/docs/8.3/static/datatype-datetime.html
seems to say that the special value ‘infinity’ (“later than all
other time stamps”) should work for an date-time column, and the
type “date” is listed as among the date-time
"Ken Winter" writes:
> The documentation at
> http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems to
> say that the special value 'infinity' ("later than all other time stamps")
> should work for an date-time column, and the type "date" is listed as among
> the date-time data ty
On Mon, May 17, 2010 at 1:17 PM, Ken Winter wrote:
> The documentation at
> http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems to
> say that the special value ‘infinity’ (“later than all other time stamps”)
> should work for an date-time column, and the type “date” is listed
The documentation at
http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems to
say that the special value 'infinity' ("later than all other time stamps")
should work for an date-time column, and the type "date" is listed as among
the date-time data types.
But I can't get 'infini
Gerhard Heift wrote:
> how can I store an infinity value into an interval? I want to store
> offsets to a timestamp, and for some cases i need +infinity and
> -infinity as result.
>
> I want to make something like this:
> SELECT now() + 'infinity'::interval;
>
> This should return 'infinity'::tim
recipient. Sender does
not necessarily endorse content contained within this transmission.
> Date: Sun, 21 Dec 2008 00:52:04 +0100
> From: ml-postgresql-20081012-3...@gheift.de
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] infinity interval
>
> Hello,
>
> how can I
On Sat, Dec 20, 2008 at 3:52 PM, Gerhard Heift
wrote:
> how can I store an infinity value into an interval?
I don't think you can:
postgres=# select INTERVAL '1 week' + 'infinity'::timestamp;
?column?
--
infinity
(1 row)
postgres=# select INTERVAL 'infinity' + now();
ERROR: invalid
Hello,
how can I store an infinity value into an interval? I want to store
offsets to a timestamp, and for some cases i need +infinity and
-infinity as result.
I want to make something like this:
SELECT now() + 'infinity'::interval;
This should return 'infinity'::timestamp.
Is it possible?
Tha
is there any integer constant for infinity in postgres? i know such
beasts exist (with some bugs) in the date/time domain. it would be nice
to have an abstraction for numerology as well as chronology...
-tfo
p.s. i'm not sure this ever _really_ got posted before, since i wasn't
subscribed to
is there any integer constant for infinity in postgres? i know such
beasts exist (with some bugs) in the date/time domain. it would be nice
to have an abstraction for numerology as well as chronology...
-tfo
---(end of broadcast)---
TIP 1: subsc
13 matches
Mail list logo
