Advertisement
Guest User

Untitled

a guest
Oct 10th, 2015
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.37 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION int_to_roman(a INTEGER) RETURNS TEXT AS $$
  2. BEGIN
  3.     IF a > 3000 THEN
  4.         RAISE EXCEPTION 'Number more 3000 --> %', a
  5.               USING HINT = 'Please, use number lower 3000';
  6.     ELSIF a < 0 THEN
  7.         RAISE EXCEPTION 'Negative number --> %', a
  8.               USING HINT = 'Please, use number more 0';
  9.     ELSE
  10.     RETURN to_char(a, 'FMRN');
  11.     END IF;
  12. END;
  13. $$ LANGUAGE plpgsql;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement