interval integer comparison - Mailing list pgsql-general

From Havasvölgyi Ottó
Subject interval integer comparison
Date
Msg-id 006801c565f6$1c5fae80$6c00a8c0@OTTO
Whole thread Raw
Responses Re: interval integer comparison
List pgsql-general
Hi all,

Pg 8.0.3 allows me to compare interval with integer, but I cannot see any
reasonable rule:

These are true:


1 < '1 days'::interval

2 > '1 days'::interval

999 > '1 days'::interval

1999 < '2 days'::interval

2000 != '2 days'::interval

2001 > '2 days'::interval
...

20999 < '21 days'::interval

21000 != '21 days'::interval

21001 > '21 days'::interval

and so on

Is this a bug?

Best Regards,
Otto



pgsql-general by date:

Previous
From: "Oisin Glynn"
Date:
Subject: System info in/through database on Windows 2000 Postres 8.x
Next
From: Havasvölgyi Ottó
Date:
Subject: Re: Accessing PostgreSQL from C++