Re: [HACKERS] Automatic type conversion - Mailing list pgsql-hackers

From Dave Chapeskie
Subject Re: [HACKERS] Automatic type conversion
Date
Msg-id 19980510022322.07404@ddm.on.ca
Whole thread Raw
In response to Automatic type conversion  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-hackers
On Sun, May 10, 1998 at 12:14:11AM +0000, Thomas G. Lockhart wrote:
> -- there isn't a floating point factorial operator...
> tgl=> select (4.3 !);
> ?column?
> --------
>       24
> (1 row)

Am I the only one that thinks the above is wrong?  4.3 factorial is
mathematically undefined and does NOT equal 24.

I don't think the automatic type conversion should automatically
truncate values without at least a warning.  Preferably I'd like to be
forced to do the conversion myself for cases like the above.

--
Dave Chapeskie <dchapes@ddm.on.ca>, DDM Consulting

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Automatic type conversion
Next
From: "Eugene Selkov Jr."
Date:
Subject: Re: [HACKERS] Automatic type conversion