>># delete from pref_users >>where id not in (select distinct id from pref_money) limit 10; >>ERROR: syntax error at or near "limit" >>LINE 2: ...ere id not in (select distinct id from pref_money) limit 10;
Or this? DELETE FROM pref_users WHERE id IN ( SELECT id FROM pref_users WHERE id NOT IN ( SELECT DISTINCT id FROM pref_money ) LIMIT 10 ); Saw elsewhere another suggestion with EXCEPT, which is also sexy. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general