From: | Dan S <strd911(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | timestamp convert to date |
Date: | 2010-04-30 14:39:57 |
Message-ID: | p2r7de955571004300739lc81ef155u605a5d25f78193f0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi List !
I'm running "PostgreSQL 8.3.10 on i486-pc-linux-gnu, compiled by GCC
gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3" (Ubuntu 9.04)
I want to use -infinity,infinity as my date interval maximum endpoints in an
application I'm writing .
Is it possible to use date ?
I did a test but it looks like date doesn't support infinity as a value.
However this looks like it doesn't give an error either:
select 'infinity'::timestamp::date;
it just gives me a blank row in pgadmin3 query window.
So is infinity supposed to work with date or should this conversion give an
error ?
It would be really nice with the possibility to use infinity with the date
type.
Regards
//Dan
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-04-30 14:47:34 | Re: pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required) |
Previous Message | Vincenzo Romano | 2010-04-30 14:37:57 | Re: Nuevo sobre PGday Latinoamericano 2011... |