These switches must be written before the PL/pgPSM function body together with the keyword# OPTION. The second switch invalidates all cached plans related to the function every time when the function is called. The first switch leads to the dumping of compiled code into the system log. PL/pgPSM has two function switches: DUMP and RECOMPILE. The PL/PgPSM contains the following statements:īefore starting to read about each statement, go through the following examples:ĬREATE OR REPLACE FUNCTION foo1(a integer)ĬREATE OR REPLACE FUNCTION foo2(a integer)ĬREATE OR REPLACE FUNCTION foo3(a integer) IF age >= 20 AND age =30 AND age get_sum.a) SET (name, surname, age) = (SELECT e.name, e.surname, e.age Both stored procedures select group of employees and call print_info for each group member. The following two examples show the same task, but the first implementation is considered wrong.
0 Comments
Leave a Reply. |