plpgsql是postgresql自带的语言,基本结构教程。由于是入门教程所以在略看上述教程(只需看41.1综述-41.6控制结构即可,包括41.6,因为要用到条件和循环结构)之后可直接看下面5道题目及答案,有一定编程基础的同学应该看了就会
- 编写一个函数,函数名为get_rand_phone_num,无接收参数,返回一
个随机的电话号码,长度11位,电话号码以’132’或 '137’或 '189’或
'135’开头,要求任意满足该要求的电话号码能等概率生成。
//1.随机phone
CREATE OR REPLACE FUNCTION get_rand_phone_num(OUT rand_phone varchar) AS $$
DECLARE
temp1 integer;
temp2 integer;
BEGIN
temp1 := trunc(random() * 4 + 1);
IF temp1 = 1 THEN
rand_phone := CONCAT(rand_phone, '132');
ELSEIF temp1 = 2 THEN
rand_phone := CONCAT(rand_phone, '137');
ELSEIF temp1 = 3 THEN
rand_phone := CONCAT(rand_phone, '189');
ELSE
rand_phone := CONCAT(rand_phone, '135');
END IF;
FOR i IN 1..8 LOOP
temp2 := trunc(random<