help: now() + N is now failing!

From: "Mel Jamero" <mel(at)gmanmi(dot)tv>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: help: now() + N is now failing!
Date: 2003-07-29 09:06:35
Message-ID: 000901c355b0$b6f65d70$1b06a8c0@CMPMEL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

help. does anybody know how, without using date_pli, i can make now() + N
work in newer versions of postgres?

we ported our old data to a new db.

VALUE = NULL doesn't work anymore, had to use IS NULL. had to modify
hundred liners of scripts :(

i don't wanna go about modifying all the scripts again to modify now() + N
in my old scripts.

i've been a victim of backwards compatibility issue and late side-effect of
my DB infancy sydrome years ago :(

TIA!

--OLD postgres

old_postgres=# select now();
now
------------------------
2003-07-29 16:11:11+08
(1 row)

old_postgres=# select now() + 2;
?column?
------------
2003-07-31
(1 row)

-- NEW postgres

new_postgres=# select now();
now
-------------------------------
2003-07-29 16:31:39.494534+08
(1 row)

new_postgres=# select now() + 2;
ERROR: Unable to identify an operator '+' for types 'timestamp with time
zone' and 'integer'
You will have to retype this query using an explicit cast

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message HK 2003-07-29 10:07:04 diff between two timestamps.
Previous Message Henshall, Stuart - TNP Southwest 2003-07-29 08:21:11 Re: dynamic sql statements and OUT variables