Geoffrey <lists@xxxxxxxxxxxxxxxxxxxxx> writes: > ship_date between '04/30/2010' AND '04/30/2010' + 14 > ERROR: invalid input syntax for integer: "04/30/2010" > Can I use between with dates? The problem with that is the parser has no reason to treat the strings as dates, at least not till it comes to consider the BETWEEN comparisons, which is too late to help in resolving the addition in the subexpression (data types are determined bottom-up). This'd work: ship_date between '04/30/2010' AND '04/30/2010'::date + 14 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
