zhong ming wu <mr.z.m.wu@gmail.com> 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