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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers