From: | "Mike C" <smith(dot)not(dot)western(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | SELECT and DATE Function question |
Date: | 2006-09-11 04:53:36 |
Message-ID: | bd0eabd0609102153h71fd59ffv6d0ca8a78c27fd9c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I'm trying to calculate an expiration date by adding the number of days onto
the start date. i.e. select start_date + number_of_days from blah;
create table blah (start_date timestamp, number_of_days integer);
insert into blah values (current_timestamp, 25);
select start_date + number_of_days from blah;
The error I get is:
ERROR: operator does not exist: timestamp without time zone + integer
HINT: No operator matches the given name and argument type(s). You may need
to add explicit type casts.
But according to
http://www.postgresql.org/docs/8.1/static/functions-datetime.html the +
operator should support integers and treat them as days (date '2001-09-28' +
integer '7'). Obviously typing a constant into the query is a lot different
from using the value of a column, but I would have thought it would work.
What is the correct way to make this calculation?
Cheers,
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Bono | 2006-09-11 05:27:46 | Re: SELECT and DATE Function question |
Previous Message | Martijn van Oosterhout | 2006-09-09 12:06:13 | Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. |