date_part for infinity intervals

From: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: date_part for infinity intervals
Date: 2011-06-20 09:54:59
Message-ID: 4DFF18F3.1010108@dc.baikal.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Diogo Santos 2011-06-20 10:14:55 Auto Start second postgres 8.3.15-1 instance MAC OS X
Previous Message Pavel Stehule 2011-06-20 09:49:05 patch: plpgsql - remove unnecessary ccache search when a array variable is updated