Re: [BUGS] small bug in op + between datetime and integer

2003-08-17 Thread Gaetano Mendola
From: "Tom Lane" <[EMAIL PROTECTED]> wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 exc

Re: [BUGS] small bug in op + between datetime and integer

2003-08-17 Thread Dennis Björklund
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; -- not > > > > ERROR: operator does not exist: integer + date > > HIN

Re: [BUGS] small bug in op + between datetime and integer

2003-08-16 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Anyone have an idea on this one? There's a date + integer operator, but no integer + date operator. Yawn... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our e

Re: [BUGS] small bug in op + between datetime and integer

2003-08-16 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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| h

Re: [BUGS] small bug in op + between datetime and integer

2003-08-16 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> 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

Re: [BUGS] small bug in op + between datetime and integer

2003-08-16 Thread Bruce Momjian
Oh, OK. --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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

Re: [BUGS] small bug in op + between datetime and integer

2003-08-16 Thread Bruce Momjian
Anyone 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; -- not > > ERRO

Re: [BUGS] small bug in op + between datetime and integer

2003-08-04 Thread Bruce Momjian
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; -- n