Re: Huh? Data typing bug? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Huh? Data typing bug?
Date
Msg-id 9352.991704311@sss.pgh.pa.us
Whole thread Raw
In response to Huh? Data typing bug?  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: Huh? Data typing bug?
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Grant
Date:
Subject: Re: Huh? Data typing bug?
Next
From: "Josh Berkus"
Date:
Subject: Re: Huh? Data typing bug?