> Jim C. Nasby wrote: >> Maybe a compatability layer isn't worth doing, but I certainly think >> it's very much worthwhile for the community to do everything possible to >> encourage migration from MySQL. We should be able to lay claim to most >> advanced and most popular OSS database. >> > > We'll do that by concentrating on spiffy features, not compatibility > layers. I want people to use PostgreSQL because it's the best, not > because it's just like something else. >
While I do agree with the ideal, the reality may not be good enough. Even I, a PostgreSQL user for a decade, have to use MySQL right now because that is what the client uses. Again, there is so much code for MySQL, a MySQL emulation layer, MEL for short, could allow plug and play compatibility for open source, and closed source, applications that otherwise would force a PostgreSQL user to hold his or her nose and use MySQL. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match