Re: [BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command

2006-04-24 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Actually implementing this is left as a task for someone who feels like >> hacking on the datetime code ... I don't particularly ... > I think this is a perfect project for Summer of Code. That's a thought. Another task in the same

Re: [BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command

2006-04-24 Thread Alvaro Herrera
Tom Lane wrote: > BTW, I looked at the problem a little bit and concluded that it wouldn't > be so invasive to fix as all that. The weak spot at the moment is that > parse_coerce() passes typmod -1 instead of the specified typmod to the > datatype's input routine when converting an unknown-type

Re: [BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command

2006-04-24 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> We don't currently support that style of specifying interval constants, >> and you shouldn't hold your breath expecting it to happen --- it will >> require a whole bunch of abuse of the currently data-type-independent >> processing of literal constants.

Re: [BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command

2006-04-24 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > That is definately a bug: > > test=> SELECT INTERVAL '100' YEAR; > > We don't currently support that style of specifying interval constants, > and you shouldn't hold your breath expecting it to happen --- it will > require a whole bunch of abuse of

Re: [BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command

2006-04-24 Thread Tom Lane
Bruce Momjian writes: > That is definately a bug: > test=> SELECT INTERVAL '100' YEAR; We don't currently support that style of specifying interval constants, and you shouldn't hold your breath expecting it to happen --- it will require a whole bunch of abuse of the currently data-type-inde

Re: [BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command does not work

2006-04-24 Thread Bruno Wolff III
On Sat, Apr 22, 2006 at 20:34:03 +, "Harry E. Clarke" <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 2403 > Logged by: Harry E. Clarke > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.3 > Operating system: Suse Li

Re: [BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command

2006-04-24 Thread Bruce Momjian
Harry E. Clarke wrote: > > The following bug has been logged online: > > Bug reference: 2403 > Logged by: Harry E. Clarke > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.3 > Operating system: Suse Linux 10.0 > Description:Date arithemtic using INTERVAL in

[BUGS] BUG #2403: Date arithemtic using INTERVAL in UPDATE command does not work

2006-04-24 Thread Harry E. Clarke
The following bug has been logged online: Bug reference: 2403 Logged by: Harry E. Clarke Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Suse Linux 10.0 Description:Date arithemtic using INTERVAL in UPDATE command does not work Details: