On 2/17/12 12:04 PM, Robert Haas wrote:
> The argument isn't about whether the user made the right design
> choices; it's about whether he should be forced to insert an explicit
> type cast to get the query to do what it is unambiguously intended to
> do.
I don't find INTEGER LIKE '1%' to be unambiguous.
Prior to this discussion, if I had run across such a piece of code, I
couldn't have told you what it would do in MySQL without testing.
What *does* it do in MySQL?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com