Scott, > the sad thing is that while MySQL implemented a -ansi switch that > supposedly turns on ansi compliance, it only fixes about 1/2 of all the > non-compliance issues. Yet another half-implemented feature... :) Plus they completely broke ansi-compliance with the latest version of mysqldump, which is what I'm struggling with. To quote one of the developers on #mysql: "Oh, that's not really a bug, it only affects ANSI mode". However, Perl is superb at pattern-matching, so I've patched for it ... -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org