search

pietermartin / sqlg

TinkerPop graph over sql
MIT License
246 stars 51 forks source link

Postgresql delete sql optimization #383

Open pietermartin opened 4 years ago

pietermartin commented 4 years ago

postgresql delete sql should rather use the following pattern

delete from table a using
(values()) as tmp(within)
where a.ID = tmp.within