Thread: Huh? Data typing bug?

Folks,
I just subtracted two dates and got an INT4, rather than the INTERVAL I
was expecting.  What goes on here?

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 

You got difference in seconds as the result?

Show some examples.

"Josh Berkus" <josh@agliodbs.com> writes:
>     I just subtracted two dates and got an INT4, rather than the INTERVAL I
> was expecting.  What goes on here?

IIRC, number of days (as an int) is what that's supposed to produce.

If that's not what you wanted, maybe you ought to cast the dates to
timestamp or some such.
        regards, tom lane

Tom,

> IIRC, number of days (as an int) is what that's supposed to produce.
> 
> If that's not what you wanted, maybe you ought to cast the dates to
> timestamp or some such.

I see.  It was never made clear to me that here the DATE type differs
from DATETIME and TIMESTAMP significantly.  

This makes some sort of sense, now.

Correct me if I'm wrong:

DATE + INT4 = DATE
DATE - DATE = INT4

But:

DATETIME + INTERVAL = DATETIME
DATETIME - DATETIME = INTERVAL

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco