Kris Jurka wrote:
> Bruce Momjian wrote:
> > Log Message:
> > -----------
> > Add 'day' field to INTERVAL so 1 day interval can be distinguished from
> > 24 hours. This is very helpful for daylight savings time:
> >
>
> Seems to have broken the contrib/btree_gist interval regression tests
>
> http://pgbuildfarm.org/cgi-bin/show_...-20%2017:30:00

I have applied a patch which adds the 'date' value for interval to the
code. However, the regression still does not pass. Here is a query:

SELECT count(*) FROM intervaltmp WHERE a = '199 days 21:21:23'::interval;
count
-------
1
(1 row)

that should return 1, but returns 0 in the current code. Does anyone
have any ideas on a fix?

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org