Postgres Pro
Downloads
Home   >   mailing lists

Re: MySQL search query is not executing in Postgres DB - Mailing list pgsql-hackers

From Don Baccus
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id D55A0FD7-E6A5-4AF9-BE5E-31BE69F479B8@pacifier.com
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Rob Wultsch <wultsch@gmail.com>)
Responses Re: MySQL search query is not executing in Postgres DB
Re: MySQL search query is not executing in Postgres DB
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: pgsql_fdw, FDW for PostgreSQL server
Next
From: Dimitri Fontaine
Date:
Subject: Re: Command Triggers