Re: [SQL] Data type confusion

2001-08-05 Thread Josh Berkus
Tom, > > then why does > > INTERVAL / INTERVAL = ERROR? > > Because no one got around to creating an INTERVAL / INTERVAL > operator. > There are plenty of such gaps in our operator set... Bummer. If I could "C" then maybe I'd do something about it. > > > Shouldn't > > INTERVAL / INTERVAL = I

Re: [SQL] Data type confusion

2001-08-05 Thread Tom Lane
"Josh Berkus" <[EMAIL PROTECTED]> writes: > If > INTERVAL / INTEGER = INTERVAL Actually the operator appears to be INTERVAL / FLOAT8. > then why does > INTERVAL / INTERVAL = ERROR? Because no one got around to creating an INTERVAL / INTERVAL operator. There are plenty of such gaps in our operat