Brendan Jurd <blakjak(at)blakjak(dot)sytes(dot)net> writes:
> Of course, it would be possible to create a shorthand version of the
> function which expects (text, interval), and passes directly to
> time_span($1, now(), $2).
This bothers me a bit. That essentially says that (text, interval)
has a hidden instability: the results depend on when you execute it.
If we allow this form, it should be restricted to only those units
(values of the text parameter) for which the result would *not*
depend on now().
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Brendan Jurd||Date: 2005-01-15 06:25:41|
|Subject: Re: Time span conversion function|
|Previous:||From: Bruce Momjian||Date: 2005-01-15 06:01:35|
|Subject: On schedule for 8.0.0 packaging on Monday|