Advertisement
bAngelov

PostgreSQL Function Live Template

Jun 3rd, 2024
781
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 0.91 KB | None | 0 0
  1. <template name="func" value="CREATE OR REPLACE FUNCTION fn_$function_name$($function_values$)&#10;RETURNS $return_type$ AS&#10;$$$$&#10;    DECLARE&#10;        declaration_availability_var INT;&#10;        $variables_to_declare$&#10;    BEGIN&#10;        $function_declaration$&#10;    END;&#10;$$$$&#10;LANGUAGE plpgsql;" description="Create postgresql function" toReformat="true" toShortenFQNames="true">
  2.   <variable name="function_name" expression="" defaultValue="" alwaysStopAt="true" />
  3.   <variable name="function_values" expression="" defaultValue="" alwaysStopAt="true" />
  4.   <variable name="return_type" expression="" defaultValue="" alwaysStopAt="true" />
  5.   <variable name="variables_to_declare" expression="" defaultValue="" alwaysStopAt="true" />
  6.   <variable name="function_declaration" expression="" defaultValue="" alwaysStopAt="true" />
  7.   <context>
  8.     <option name="SQL" value="true" />
  9.   </context>
  10. </template>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement