| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, premanand <kottiprem(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: MySQL search query is not executing in Postgres DB |
| Date: | 2012-02-17 20:05:43 |
| Message-ID: | 4F3EB317.3060800@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2012-02-17 20:40:13 | Re: Triggers with DO functionality |
| Previous Message | Robert Haas | 2012-02-17 20:04:59 | Re: MySQL search query is not executing in Postgres DB |