SELECT and DATE Function question

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

Responses

Browse pgsql-admin by date

  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.