| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | Christopher Browne <cbbrowne(at)gmail(dot)com> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, 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 19:39:17 |
| Message-ID: | F18C1E11-E508-4D66-B3CB-6763B89D6598@pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Feb 17, 2012, at 11:28 AM, Christopher Browne wrote:
> And I have *zero* confidence that for PostgreSQL to rule out "LIKE
> '1%'" is preventing those designs from getting built...
>
> When confronted by a difficult problem, solve it by reducing it to the
> question, "How would the Lone Ranger handle this?"
He would turn to Tonto, who undoubtably would advise:
If you want to treat an integer like a string, figure out how to convert your integer into a string …
The original query strikes me as being similar to expecting the Lone Ranger's six-shooter to be capable of shooting Tonto's arrows.
----
Don Baccus
http://donb.photo.net
http://birdnotes.net
http://openacs.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2012-02-17 19:40:15 | Re: Designing an extension for feature-space similarity search |
| Previous Message | Jay Levitt | 2012-02-17 19:32:18 | Re: Designing an extension for feature-space similarity search |