Hey Joe,

I've found and solved what I think was a small bug with Add Category in the mp_blogcategories_select_bymodule stored proc on postgresql. If you added a new category but didn't attach it to a new blog entry the category never showed up on the page. Then you would have the entry in the database but no way to attach new blog entries to it. I’ve solved it in the stored proc below with a left outer join.

Take a look and let me know if it works as advertised.

Take Care

Phil



CREATE OR REPLACE FUNCTION mp_blogcategories_select_bymodule( int4) RETURNS SETOF mp_blogcategories_select_bymodule_type AS
$BODY$

select
bc.categoryid,
bc.moduleid,
bc.category,
count(bic.itemid) as postcount
from
mp_blogcategories bc

left outer join mp_blogitemcategories bic
on bc.categoryid = bic.categoryid


where bc.moduleid = $1

group by bc.categoryid, bc.moduleid, bc.category

order by bc.category;$BODY$
LANGUAGE 'sql' VOLATILE SECURITY DEFINER;