 | |
Re: [BUGS] small bug in op + between datetime and integer
mailing.database.pgsql-bugs mailing.database.pgsql-bugs
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: [BUGS] small bug in op + between datetime and integer -
08-16-2003
, 11:14 PM
|
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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings |
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
#2
| |||
| |||
|
|
Bruce Momjian <pgman (AT) candle (DOT) 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 (AT) candle (DOT) 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
#3
| |||
| |||
|
|
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"? |
have such an operator (do they?) and I see no clear advantage to adding
one.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
#4
| |||
| |||
|
|
Bruce Momjian <pgman (AT) candle (DOT) pha.pa.us> writes: Anyone have an idea on this one? There's a date + integer operator, but no integer + date operator. Yawn... |
--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.