On Tue, Dec 13, 2005 at 08:36:12AM -0600, David Rogers wrote: > Needless to say, this fall we began the conversion to PostgreSQL 8 and > we couldn't be more pleased. As a part of the conversion I found several > new bugs in MySQL due to PostgreSQL complaining about some of my old > queries. The most egregious of these are MySQL silently truncating var > chars that are too long for the column and silently allowing one to > insert a quoted string into an integer column. Ouch! We won't be using > MySQL for any new work here and will eventually migrate all of our > applications to PostgreSQL. You should make sure all that stuff is reported in the gotchas: http://sql-info.de/mysql/gotchas.html -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461