Bill Moran <wmo...@potentialtech.com> writes: > In response to Tom Lane <t...@sss.pgh.pa.us>: >> I have never heard of any programming system anywhere that accepts such >> a syntax for integers (assuming it distinguishes integers from other >> numbers at all). I'm not excited about being the first.
> But > SELECT 1.000::Integer; > works. And so does Sure. That's a datatype conversion, though; it's not a case of taking the value as an integer natively. > One of the exciting (but possibly wrong) arguments in favor of this is the > fact that some programming languages will output integers in exponential > notation when the numbers are very large (PHP is the only example that > comes to mind, but it's a pretty common language) Just another example of the fact that PHP was designed by incompetent amateurs :-( http://www.junauza.com/2010/12/top-50-programming-quotes-of-all-time.html regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers