Horton

Re: MySQL search query is not executing in Postgres DB

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: Rob Wultsch <wultsch@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>, pgsql-hackers@postgresql.org
Date: 2012-02-18T21:12:04Z
Lists: pgsql-hackers 
On Feb 18, 2012, at 12:57 PM, Rob Wultsch wrote:
> 
> Where first_name is string the queries above have very different
> behaviour in MySQL. The first does a full table scan and coerces
> first_name to an integer (so '5adfs' -> 5) 

Oh my, I can't wait to see someone rise to the defense of *this* behavior!

----
Don Baccus
http://donb.photo.net
http://birdnotes.net
http://openacs.org