Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. DECLARE
  2. conf_param text;
  3. num integer;
  4.  
  5. BEGIN
  6. SELECT current_setting('the_setting') INTO conf_param; -- here is where dies when the_setting is not recognized
  7. IF FOUND THEN
  8. num := conf_param::integer;
  9. ELSE
  10. num := NULL;
  11. END IF;
  12. -- more stuff
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement