time in 7.2

From: "Andrew Bartley" <abartley(at)evolvosystems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: time in 7.2
Date: 2002-05-07 01:18:46
Message-ID: 001e01c1f565$22b4c9a0$3200a8c0@abartleypc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am in the middle of converting our application from 7.1 to 7.2. I am encountering a whole host of problems with date time processing. I have found a way around most of them thus far. But this one I have not yet fixed.

In the following code the "first_time" column is a time type.. without time zone.

select * from visitorhistory
where visitorhistory.first_time > current_time - interval '10 minutes'

The result

ERROR: Unable to identify an operator '>' for types 'time without time zone' and 'time with time zone'

You will have to retype this query using an explicit cast (State:S1000, Native Code:7)

Stuffed if I can make this work. Can some one point me in the right direction?

Thanks

Andrew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2002-05-07 01:45:02 Re: postgresql 7.1.3
Previous Message Gregory Seidman 2002-05-07 01:05:55 Re: help with *mysql*