small bug in op + between datetime and integer - Mailing list pgsql-bugs

From Pavel Stehule
Subject small bug in op + between datetime and integer
Date
Msg-id Pine.LNX.4.44.0308040748370.29876-100000@kix.fsv.cvut.cz
Whole thread Raw
Responses Re: small bug in op + between datetime and integer
Re: small bug in op + between datetime and integer
List pgsql-bugs
Hello

It is maybe not bug, but I didn't find any warning about this behavior.

select current_date + 1;  -- ok
select 1 + current_date;  -- not

ERROR:  operator does not exist: integer + date
HINT:  No operator matches the given name and argument type(s). You may
need to add explicit typecasts.

I use CVS version of PostgreSQL from last week

regards

Pavel Stehule

pgsql-bugs by date:

Previous
From: "Eric Johnson"
Date:
Subject: Re: Using contrib/fulltext on multiple tables.
Next
From: Tom Lane
Date:
Subject: Re: PG 7.3.1 with ssl on linux hangs (testcase available)