small bug in op + between datetime and integer
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
I can verify this is an existing bug in CVS.
---------------------------------------------------------------------------
Pavel Stehule wrote:
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; -- notERROR: 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073Anyone have an idea on this one?
---------------------------------------------------------------------------
Pavel Stehule wrote:
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; -- notERROR: 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Bruce Momjian <pgman@candle.pha.pa.us> writes:
Anyone have an idea on this one?
There's a date + integer operator, but no integer + date operator.
Yawn...
regards, tom lane
Tom Lane wrote:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
Anyone have an idea on this one?
There's a date + integer operator, but no integer + date operator.
Yawn...
Uh, "Yawn" means we don't need to fix it, or "oh, here's another one"?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073Bruce Momjian <pgman@candle.pha.pa.us> writes:
Tom Lane wrote:
There's a date + integer operator, but no integer + date operator.
Yawn...
Uh, "Yawn" means we don't need to fix it, or "oh, here's another one"?
It means "I can't get excited about it." The docs don't claim that we
have such an operator (do they?) and I see no clear advantage to adding
one.
regards, tom lane
Oh, OK.
---------------------------------------------------------------------------
Tom Lane wrote:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
Tom Lane wrote:
There's a date + integer operator, but no integer + date operator.
Yawn...Uh, "Yawn" means we don't need to fix it, or "oh, here's another one"?
It means "I can't get excited about it." The docs don't claim that we
have such an operator (do they?) and I see no clear advantage to adding
one.regards, tom lane
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
On Sun, 17 Aug 2003, Bruce Momjian wrote:
Anyone have an idea on this one?
It is maybe not bug, but I didn't find any warning about this behavior.
select current_date + 1; -- ok
select 1 + current_date; -- notERROR: operator does not exist: integer + date
HINT: No operator matches the given name and argument type(s). You may
need to add explicit typecasts.
It's not a bug. The operator + has one definition of the type
(date,integer) -> date
but there is no definition for
(integer,date) -> date
Instead of integer one can also have an interval. So if you start with a
date you can add an interval to it. But if you start with a time interval
you can not add a date to it. What would it mean to add a date to
something? I have no idea. Well, that's the logic behind the current
behaviour.
It would of course not be difficult to add a definition of + with the
integer first and the date as the second argument. To me it's not much of
an improvement, but it's not for me to decide. The postgresql operator +
is not the same as the mathematical operator + and it does not have the
same properties.
--
/Dennis
From: "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
Tom Lane wrote:
There's a date + integer operator, but no integer + date operator.
Yawn...Uh, "Yawn" means we don't need to fix it, or "oh, here's another one"?
It means "I can't get excited about it." The docs don't claim that we
have such an operator (do they?) and I see no clear advantage to adding
one.
Well, I think that have the operator integer + date is not necessary but is
better to have just to forget that not exist each time that someone wrote an
expression involving integer and date.
Regards
Gaetano Mendola