SQLize Online / PHPize Online  /  SQLtest Online

CREATE OR REPLACE FUNCTION array_reverse(anyarray) RETURNS anyarray AS $$ SELECT ARRAY( SELECT $1[i] FROM generate_subscripts($1,1) AS s(i) ORDER BY i DESC ); $$ LANGUAGE 'sql' STRICT IMMUTABLE; CREATE TABLE test2 ( domain varchar, domain_path varchar[] ); CREATE OR REPLACE FUNCTION domain_reverse() RETURNS TRIGGER AS $$ BEGIN NEW.domain_path := string_to_array(NEW.domain, '.'); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER xtrig BEFORE INSERT OR UPDATE ON test2 FOR EACH ROW EXECUTE PROCEDURE domain_reverse(); INSERT INTO test2 (domain) values ('https://sqlize.online'); SELECT * FROM test2;