small bug in op + between datetime and integer

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: small bug in op + between datetime and integer
Date: 2003-08-04 05:56:18
Message-ID: Pine.LNX.4.44.0308040748370.29876-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-08-04 17:29:01 Re: PG 7.3.1 with ssl on linux hangs (testcase available)
Previous Message Eric Johnson 2003-08-04 03:06:27 Re: Using contrib/fulltext on multiple tables.