Re: interval * numeric operator - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: interval * numeric operator
Date
Msg-id 87pryk97tz.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: interval * numeric operator  (Josh Berkus <josh@agliodbs.com>)
Responses Re: interval * numeric operator  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
"Josh Berkus" <josh@agliodbs.com> writes:

> Peter Eisentraut wrote:
>> There are interval * double precision operators (both ways) but none for
>> interval * numeric.  Adding this would make sense since interval is now
>> optionally stored as fixed-point internally.  Any objections to adding this
>> in 8.4?
>
> +1
>
> I've been casting to Numeric anyway.

Shouldn't the cast be implicit anyways? What does having double precision
operators buy us? Wouldn't it introduce ambiguities?


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support!


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Test lab
Next
From: "Gevik Babakhani"
Date:
Subject: Re: Feature Request: inline comments