date_part for infinity intervals - Mailing list pgsql-hackers

From Vlad Arkhipov
Subject date_part for infinity intervals
Date
Msg-id 4DFF18F3.1010108@dc.baikal.ru
Whole thread Raw
Responses Re: date_part for infinity intervals
List pgsql-hackers
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?


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: patch: plpgsql - remove unnecessary ccache search when a array variable is updated
Next
From: Simon Riggs
Date:
Subject: Re: patch: plpgsql - remove unnecessary ccache search when a array variable is updated