Re: [HACKERS] date_part for infinity intervals

2011-06-21 Thread Robert Haas
On Mon, Jun 20, 2011 at 5:54 AM, Vlad Arkhipov wrote: > The behaviour of date_part function is opaque for infinity intervals. For > example > date_part('epoch', 'infinity'::date) and date_part('year', 'infinity'::date) > return zero but is supposed to return 'infinity', > date_part('day', 'infinit

[HACKERS] date_part for infinity intervals

2011-06-20 Thread Vlad Arkhipov
The behaviour of date_part function is opaque for infinity intervals. For example date_part('epoch', 'infinity'::date) and date_part('year', 'infinity'::date) return zero but is supposed to return 'infinity', date_part('day', 'infinity'::date) returns zero, should it return 'NaN' instead? -- S