X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 378E0475EFD for ; Thu, 10 Apr 2003 13:36:17 -0400 (EDT) Received: from post.webmailer.de (natsmtp00.webmailer.de [192.67.198.74]) by postgresql.org (Postfix) with ESMTP id 69CCD475AE5 for ; Thu, 10 Apr 2003 13:36:15 -0400 (EDT) Received: from ianb.local (pD9EB1444.dip.t-dialin.net [217.235.20.68]) by post.webmailer.de (8.12.8/8.8.7) with ESMTP id h3AHa3Hb027728; Thu, 10 Apr 2003 19:36:03 +0200 (MEST) Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: pgsql-sql@postgresql.org Subject: Re: INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Date: Thu, 10 Apr 2003 19:35:25 +0200 X-Mailer: KMail [version 1.4] References: <200304101627.43804.barwick@gmx.net> In-Reply-To: <200304101627.43804.barwick@gmx.net> Cc: Stephan Szabo , Tom Lane , Rod Taylor , Jan Wieck MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200304101935.25897.barwick@gmx.net> X-Spam-Status: No, hits=-30.8 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, RCVD_IN_NJABL,RCVD_IN_OSIRUSOFT_COM,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/171 X-Sequence-Number: 12872 On Thursday 10 April 2003 16:27, Ian Barwick wrote: > I'm currently "porting" a smallish application from Postgres > to MySQL [*].=20 Many thanks for all your feedback on this. I've just had a very long and frustrating afternoon coercing the app to work with MySQL ("it's what the customers have") and was harbouring thoughts of committing unspeakable acts of violence to inanimate objects. [ Incoherent rambling rant about database software which happily and warninglessly accepts swathes of syntax= it has every intention of ignoring silently snipped]. Anyway, that's another point for my growing MySQL gotcha list. Ian Barwick barwick@gmx.net