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. I'll if I have to. I was pulling my hair out because it happens only with a specific date range and can't be my invalid format in select statement. Say i do psql> select * from shipping where ship_date <= '04/22/2008' and ship_date>='04/21/2008' it works but if i do psql> select * from shipping where ship_date <= '04/22/2010' and ship_date>='04/21/2010' it won't even perform the query but emits the error. Both server and client are 8.4.3 I tried other date formats but above format should work because it works with 2008 year. Thanks for any suggestion -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
