create type "sandbox"."type_sitesettings" AS (
        "module" character varying (50),
         "enabled" boolean,
         "title" character varying  (75),
         "link" character varying  (255)
);

CREATE OR REPLACE FUNCTION sandbox.getsitesettings()
  RETURNS SETOF sandbox.type_sitesettings AS
$BODY$
DECLARE
      rec sandbox.type_sitesettings;
BEGIN
      SELECT INTO rec 'eventCalendar' as module,
                      EXISTS(SELECT 1 FROM information_schema.tables 
                              WHERE table_schema = 'sandbox' 
                                AND table_name = 'eventcalendar') As enabled,
                      'Events' as title,
                      '/admin/modules/calendar/' as link;
      RETURN NEXT rec;

      SELECT INTO rec 'memberSystem' as module,
                      EXISTS(SELECT 1 FROM information_schema.tables 
                              WHERE table_schema = 'sandbox' 
                                AND table_name = 'memberSystem') As enabled,
                      'Members' as title,
                      '/admin/modules/members.aro' as link;
      RETURN NEXT rec;

      SELECT INTO rec 'shoppingcartSystem' as module,
                      EXISTS(SELECT 1 FROM information_schema.tables 
                              WHERE table_schema = 'sandbox' 
                                AND table_name = 'shoppingcartSystem') As enabled,
                      'Shopping Cart' as title,
                      '/admin/modules/shopcart/' as link;
      RETURN NEXT rec;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100
  ROWS 3;
ALTER FUNCTION sandbox.getsitesettings() OWNER TO postgres;

select * from "sandbox".getsitesettings();