Re: MySQL search query is not executing in Postgres DB

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