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

[SQL] Data type confusion

2001-08-05 Thread Josh Berkus
Tom, Stephan, I'm writing up the date/time FAQ, and I came across some operator behavior that confuses me: If INTERVAL / INTEGER = INTERVAL then why does INTERVAL / INTERVAL = ERROR? Shouldn't INTERVAL / INTERVAL = INTEGER? I'd like to answer this before I finish the FAQ, as it seems inconsis