From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | infinity as a date |
Date: | 2002-12-11 07:11:12 |
Message-ID: | 3DF6E510.4090101@mega-bucks.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I see that Postgres has a special keyword "infinity" for use with
timestamps. Is there an equivalent for dates?
It seems I can set a date field to be 'infinity'::timestamp, but I can't
find a way to then query a table for fields that are 'infinity' ...
I tried the following but it doesn't quite work:
JC=# create table test(a date);
CREATE TABLE
JC=# insert into test values('infinity'::timestamp);
INSERT 1030323 1
JC=# select * from test;
a
---
(1 row)
JC=# select * from test where a='infinity'::timestamp;
a
---
(0 rows)
Is there a correct way to represent a date that is "later/earlier than
any other date"?
Thanks!
Jc
From | Date | Subject | |
---|---|---|---|
Next Message | Al Sutton | 2002-12-11 07:16:10 | Re: [mail] Re: 7.4 Wishlist |
Previous Message | Joseph Shraibman | 2002-12-11 03:21:07 | Re: Urgent need of (paid) PostgreSQL support in New |