Home > mailing lists

Delete from right join - Mailing list pgsql-novice

From	Chad Thompson
Subject	Delete from right join
Date	January 7, 2003 18:10:36
Msg-id	00da01c2b688$8c5a2280$32021aac@chad Whole thread Raw
Responses	Re: Delete from right join ("Josh Berkus" <josh@agliodbs.com>)
List	pgsql-novice

I have the following query

select project_lists.*
FROM temp_lol RIGHT JOIN project_lists ON temp_lol.project_id = project_lists.project_id
WHERE temp_lol.project_id Is Null

I run this on my postgresql 7.2.x database and it returns some 3k records.

If i use a join or a left join it returns no data.

If I do this however

DELETE

FROM temp_lol RIGHT JOIN project_lists ON temp_lol.project_id = project_lists.project_id
WHERE temp_lol.project_id Is Null

I get an error, Parse error at or near right.

I realize that right joins are evil, but I dont know what else to use to delete these 3k records from my table.

Any Ideas?

Thanks

Chad

From: Josh Berkus
Date: 06 January 2003, 20:40:52
Subject: Re: PostgreSQL-7.1.3 Installation Problem

From: "Josh Berkus"
Date: 07 January 2003, 18:57:03
Subject: Re: Delete from right join