CREATE OR REPLACE FUNCTION page(IN i_app name character varying, IN i_photo_id big int, IN i_page integer, IN i_member_id big int, OUT o_similar_page_name character varying, OUT o_similar_page_id big int, OUT o_similar_photo_id big int[])
DECLARE v_limit INTEGER := 4; v_offset INTEGER; BEGIN SET SEARCH_PATH = ''; v_start_time = DAYTIME(); i_app name = UPPER(i_app name); IF i_app name <> 'DD' THEN RAISE EXCEPTION 'Enter Valid Application Name'; END IF; IF i_page = 1 THEN v_offset := 0; ELSE v_offset := i_page * v_limit - v_limit; END IF; Please help me. Thanks in advance. Regards, Pavan. -- View this message in context: http://lucene.472066.n3.nabble.com/How-to-write-these-kind-of-functions-in-solr-data-config-xml-tp4276060.html Sent from the Solr - User mailing list archive at Nabble.com.
