On 1/4/16, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > Vitaly Burovoy wrote: > >> Majority of the votes for NULL for "other things" except epoch. >> Nobody answers about differences between monotonic and oscillating >> values. >> >> I suppose behavior of monotonic values (julian, century, decade, >> isoyear, millennium and year) should be the same as for epoch (which >> obviously also monotonic value). >> Proposed patch has that behavior: +/-infinity for epoch, julian, >> century, decade, isoyear, millennium and year; NULL for other fields. > > It seems we got majority approval on the design of this patch, and no > disagreement; the last submitted version appears to implement that. > There's no documentation change in the patch though. I'm marking it as > Waiting on Author; please resubmit with necessary doc changes. > > Thanks, > > -- > Álvaro Herrera http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services >
Thank you! Version 3 of the patch with touched documentation in the attachment. I decided to mark it as a note, because that separation (monotonic/oscillation fields) is not obvious and for most values the function "extract" works as expected (e.g. does not give an error) until special values are (casually?) passed. -- Best regards, Vitaly Burovoy
extract_from_infinite_timestamp-v3.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
