On Sat, Apr 12, 2008 at 4:53 AM, philwalk <[EMAIL PROTECTED]> wrote: > CREATE TABLE > psql:pg83bug.sql:16: ERROR: operator does not exist: timestamp without > time zone ~~ unknown > LINE 3: where date like '2007-01-19%'; > ^ > HINT: No operator matches the given name and argument type(s). You > might need to add explicit type casts.
This isn't a bug. 8.3 removes a bunch of implicit casts to text which led to unappropriate behaviours. Prior to 8.3, your timestamp was casted to text implicitely. Just use date_trunc (http://www.postgresql.org/docs/current/static/functions-datetime.html): update bugtab set pnum = -8.6 where date_trunc('day', date) = '2007-01-19'; You can add a functional index on date_trunc('day', date) if necessary. -- Guillaume -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
