Friday, April 16, 2010

SQL for removing invalid foreign keys and typecasting in Postgres


DELETE FROM session_data WHERE session_data.name = 'user_id'
AND NOT EXISTS
(SELECT * FROM users WHERE CAST(session_data.value AS integer) = users.id);

No comments:

Post a Comment