Postgres Pro
Downloads
Home   >   mailing lists

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  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: small bug in op + between datetime and integer  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Tree view 
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)