Re: Huh? Data typing bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Huh? Data typing bug?
Date: 2001-06-05 01:25:11
Message-ID: 9352.991704311@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Josh Berkus" <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-06-05 01:56:36 Re: Huh? Data typing bug?
Previous Message Grant 2001-06-05 00:44:44 Re: Huh? Data typing bug?