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

From Andrew Dunstan
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id 4F3EB317.3060800@dunslane.net
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

On 02/17/2012 02:52 PM, Robert Haas wrote:
> If we really believed that implicit casts any form were evil, we would 
> have removed them entirely instead of trimming them back. I don't see 
> why it's heretical to suggest that the 8.3 casting changes brought us 
> to exactly that point in the universe where everything is perfect and 
> nothing can be further improved; does anyone seriously believe that? 

I don't believe we are necessarily at a perfect place, nor have I said 
it, nor has anyone else that I'm aware of. Neither am I opposed to 
implementing MySQL features (or doing them better) when appropriate.

But I do believe that a test for "intval like '1%'" is very likely to 
come from a broken design.

cheers

andrew


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: MySQL search query is not executing in Postgres DB
Next
From: Dimitri Fontaine
Date:
Subject: Re: Triggers with DO functionality