zhong ming wu <mr.z.m.wu@xxxxxxxxx> writes: > I have a postgres table with a column type abstime. (all data in this > database are loaded from an ancient propriety database) > When I filter data from this table with a specific date range on this > column it works. When I filter with a different date range > it gives me an error like > invalid abstime to timestamp > I don't have that server at this moment and I cannot post exact error. The closest thing I can find to that in the code is cannot convert abstime "invalid" to timestamp The abstime type does have a special reserved value "invalid", while timestamp doesn't so that value can't be converted to timestamp. I'm guessing that you have an "invalid" or two lurking in the table somewhere, but it's hard to be specific with so few details. You've not shown us enough information to tell why your query would be trying to convert any abstime values to timestamp --- let alone that particular one. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
