infinity as a date

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

Responses

Browse pgsql-general by date

  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