Re: [SQL] Huh? Data typing bug?

[Tom Lane]

"Josh Berkus" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]