Re: MySQL search query is not executing in Postgres DB

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: Rob Wultsch <wultsch(at)gmail(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: MySQL search query is not executing in Postgres DB
Date: 2012-02-18 21:12:04
Message-ID: D55A0FD7-E6A5-4AF9-BE5E-31BE69F479B8@pacifier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2012-02-18 21:24:01 Re: Command Triggers
Previous Message Kohei KaiGai 2012-02-18 21:07:14 Re: pgsql_fdw, FDW for PostgreSQL server