On 03/12/10 18:41, Dan McFadyen wrote:
Hello,
I've come across an odd situation. I've had access to a database where a
the following happens:
" SELECT * FROM table WHERE name LIKE 'abc%' " returns 2 rows...
but...
" SELECT * FROM table WHERE name IN (SELECT name FROM table WHERE name
LIKE 'abc%') " returns 0 rows...
I am sorry if it was already spoken.
SELECT name FROM table WHERE name LIKE 'abc%'
EXPLAIN SELECT name FROM table WHERE name LIKE 'abc%'
EXPLAIN SELECT * FROM table WHERE name IN
(SELECT name FROM table WHERE name LIKE 'abc%')
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
