FAQ
-- Easy to duplicate on 3 different operating systems, by executing the
-- following script via psql -f pg83bug.sql

-- begin script pg83bug.sql

\set VERBOSITY verbose;

drop table if exists bugtab;

select version();

create table bugtab (
date timestamp without time zone not null
,pnum numeric
);

update bugtab set
pnum = -8.6
where date like '2007-01-19%';

-- end script pg83bug.sql

The error message reported on 3 different operating systems:

DROP TABLE

version
--------------------------------------------------------------------------------------------------------
PostgreSQL 8.3.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070925 (Red Hat 4.1.2-33)
(1 row)

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.


DROP TABLE

version
-----------------------------------------------------------------------------------------------
PostgreSQL 8.3.1 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.3
(Ubuntu 4.2.3-2ubuntu4)
(1 row)

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.


DROP TABLE
version
-----------------------------------------------------
PostgreSQL 8.3.0, compiled by Visual C++ build 1400
(1 row)

CREATE TABLE
psql:pg83bug.sql:16: ERROR: operator does not exist: timestamp without
time zone ~~ unknown at character 50
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
psql:pg83bug.sql:16: LINE 3: where date like '2007-01-19%';
psql:pg83bug.sql:16:

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedApr 12, '08 at 3:12a
activeApr 12, '08 at 8:47a
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Philwalk: 1 post Guillaume Smet: 1 post

People

Translate

site design / logo © 2021 Grokbase