Iniciar sesión
Crear cuenta
Crear cuentaCrear cuenta
DO
$$
DECLARE
i integer = 0;BEGIN
FOR i IN 0..10
LOOP
RAISE NOTICE 'Valor de la variable i es %', i;
END LOOP;
END
$$
LANGUAGE plpgsql;
DO
$$
DECLARE
i integer = 0;BEGIN
FOR i IN 0..10 STEP BY 2
LOOP
RAISE NOTICE 'Valor de la variable i es %', i;
END LOOP;
END
$$
LANGUAGE plpgsql;
DO
$$
DECLARE
i integer = 0;BEGIN
FOR i IN REVERSE 10..0
LOOP
RAISE NOTICE 'Valor de la variable i es %', i;
END LOOP;
END
$$
LANGUAGE plpgsql;
DO
$$
DECLARE
rec record;
BEGIN
DROP TABLE IF EXISTS departamentos CASCADE;
CREATE TABLE departamentos( id bigserial NOT NULL,name varchar(100) NOT NULL,
CONSTRAINT departamentos_pk PRIMARY KEY (id)
);INSERT INTO departamentos(name) values('Compras');
INSERT INTO departamentos(name) values('Almacen');
INSERT INTO departamentos(name) values('Logistica');
INSERT INTO departamentos(name) values('Produccion');
INSERT INTO departamentos(name) values('Mercadeo');
INSERT INTO departamentos(name) values('Comercial');
INSERT INTO departamentos(name) values('I+D');
INSERT INTO departamentos(name) values('Adiministracion');
INSERT INTO departamentos(name) values('Sistemas');
FOR rec IN
SELECT * FROM departamentosLOOP
RAISE NOTICE '% ==> %', rec.id, rec.name;
END LOOP;
END
$$
DO
$$
DECLARE
word varchar;
mtx varchar[];
BEGIN
mtx := '{Hola,Mundo}'::varchar[];
FOREACH word IN ARRAY mtx
LOOP
RAISE NOTICE 'Palaba encontrada ==> %', word;
END LOOP;
END
$$