Re: pgsql: Add time/date macros for code clarity: #define - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Add time/date macros for code clarity: #define
Date
Msg-id 15527.1121922511@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Add time/date macros for code clarity: #define  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pgsql: Add time/date macros for code clarity: #define
List pgsql-committers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> In short, I don't think this is an improvement.

> The problem is that 24 or 30 or 60 doesn't really say what it is, while
> the macros are self-documenting.

Except that they're NOT.

Anyone who is reading datetime code will be entirely familiar with the
Gregorian calendar (and if they aren't, the macro names you propose are
not going to help them).  You cannot honestly sit there and say that
"365" or "24" isn't going to convey anything to anyone who could
usefully read the code in the first place.

> What we can do is to rename them to AVG_* macros so it is clear it is
> approximate.

But still not clear which approximation is being used.  And in most
places where this might be used, that matters.

            regards, tom lane

pgsql-committers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: pgsql: Add time/date macros for code clarity:
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql: Add time/date macros for code clarity: #define