Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Collapse
Posted by Justin Palmer on
This doesn't answer your question, but someone might find it helpful...  Postgres 7.3 will also do some funky stuff when you try to do "+" or "-" between timestamps and integers.  You can find a fix for this which works great at:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=bg5cbj%241map%241%40FreeBSD.csie.NCTU.edu.tw&rnum=3&prev=/groups%3Fq%3DUnable%2Bto%2Bidentify%2Ban%2Boperator%2Bfor%2Btypes%2B%27timestamp%2Bwith%2Btime%2Bzone%27%2Band%2B%27integer%27%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3Dbg5cbj%25241map%25241%2540FreeBSD.csie.NCTU.edu.tw%26rnum%3D3