X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.main.git;a=blobdiff_plain;f=yarrg%2Fdevel-notes;h=430523adfd3c9e069b426eebf7c30cf61c70f66d;hp=f4f6066788c045383e68aac313b237c156e65d85;hb=3a24aecf857292701d755173ffdb91d10a3426c8;hpb=38888dbd9221f97b1886ee545d0113c88432556a diff --git a/yarrg/devel-notes b/yarrg/devel-notes index f4f6066..430523a 100644 --- a/yarrg/devel-notes +++ b/yarrg/devel-notes @@ -1,21 +1,4 @@ -removing an obsolete commodity: - - select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname = 'Black dye' limit 10; - -if that produces no output then: - - begin; - delete from commods where commodname like 'Black dye'; - select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname is null limit 10; - -and if that produces no output then: - commit; -otherwise - rollback; - -======================================= - ceb's example route: alpha,byrne,papaya,turtle,jorvik,luthien