On Mar 11, 2008, at 2:50 PM, A. Kretschmer wrote:
i.e ... WHERE pt.created_date >= '2008-01-21'You can't compare a date or timestamp to a varchar or text. For your example, cast the date-string to a real date like:
Since which version of Pg?Queries like the above have worked for me from 7.3 up thru 8.1, which is my current production environment.
-- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
