On Wed, Apr 13, 2016 at 3:48 PM, Daniel Lenski wrote:
> On Wed, Apr 13, 2016 at 12:35 PM, Tom Lane wrote:
> > Jim Nasby writes:
> >> Actually, after looking at the code for interval_lt, all that needs to
> >> happen to add this support is to expose interval_cmp_internal() as a
> >> strict funct
On Wed, Apr 13, 2016 at 12:35 PM, Tom Lane wrote:
> Jim Nasby writes:
>> Actually, after looking at the code for interval_lt, all that needs to
>> happen to add this support is to expose interval_cmp_internal() as a
>> strict function. It already does exactly what you want.
>
> interval_cmp() is
Jim Nasby writes:
> Actually, after looking at the code for interval_lt, all that needs to
> happen to add this support is to expose interval_cmp_internal() as a
> strict function. It already does exactly what you want.
interval_cmp() is already SQL-accessible.
regards,
On 4/13/16 1:36 PM, Daniel Lenski wrote:
Hi all,
Is there a good reason why the SIGN() function does not work with the
INTERVAL type? (It is only defined for numeric types.)
(http://www.postgresql.org/docs/9.5/static/functions-math.html)
The only thing that comes to mind is you can get some str
Hi all,
Is there a good reason why the SIGN() function does not work with the
INTERVAL type? (It is only defined for numeric types.)
(http://www.postgresql.org/docs/9.5/static/functions-math.html)
select sign(-3); -- okay
select sign(interval '4 years'); -- ERROR: function sign(interval)
does not
