help: now() + N is now failing!
От | Mel Jamero |
---|---|
Тема | help: now() + N is now failing! |
Дата | |
Msg-id | 000901c355b0$b6f65d70$1b06a8c0@CMPMEL обсуждение исходный текст |
Ответы |
Re: help: now() + N is now failing!
Re: help: now() + N is now failing! |
Список | 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
В списке pgsql-novice по дате отправления: