Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 134D92E0116 for ; Sat, 23 Feb 2008 01:50:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 52588-04 for ; Sat, 23 Feb 2008 01:50:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ED9C32E012E for ; Sat, 23 Feb 2008 01:50:25 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1N5oNLj013415; Sat, 23 Feb 2008 00:50:24 -0500 (EST) To: Ken Johanson cc: pgsql-sql@postgresql.org Subject: Re: SQL standards in Mysql In-reply-to: <47BF1B32.2050800@kensystem.com> References: <47BF1B32.2050800@kensystem.com> Comments: In-reply-to Ken Johanson message dated "Fri, 22 Feb 2008 11:57:54 -0700" Date: Sat, 23 Feb 2008 00:50:23 -0500 Message-ID: <13414.1203745823@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/172 X-Sequence-Number: 30263 Ken Johanson writes: > Here's one Mysql developer's response to adding (fixing) the > integer/bigint/tinyint types to their CAST function: > http://bugs.mysql.com/bug.php?id=34562 Hmm ... while I'm certainly not someone to defend mysql on a regular basis, I can see their point of view here. They are supporting a limited (and clearly documented) subset of the SQL spec in this area, so it's surely a feature request rather than a bug that they don't support more. The disagreement seems to come down to what the priority of the feature addition ought to be. We have a few sore spots of our own on questions like this one, so I'm disinclined to throw the first stone ... regards, tom lane