[GENERAL] using EXISTS instead of IN: how?

[Rory Campbell-Lange]

I have been informed that at present (postgres 7.3.2) using IN is not
advised, and I should  replace it with EXISTS. I can't seem to get it to
work.

I've tried replacing (example):

    SELECT
        name
    FROM
        people
    WHERE
        state IN (
            SELECT 
                id 
            FROM 
                states
            WHERE
                name ~* 'r'
        );

with

    SELECT
        name
    FROM
        people
    WHERE
        exists (
            SELECT 
                1
            FROM 
                states
            WHERE
                name ~* 'r'
        );

However the second example simply finds all records in people.

Thanks for any help,
Rory

-- 
Rory Campbell-Lange 
<[EMAIL PROTECTED]>
<www.campbell-lange.net>

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match