DataObjects/Core_group.php

[Pman.Core] / mysql / person_get_action_type.sql

DROP FUNCTION IF EXISTS person_get_action_type;

DELIMITER $$
CREATE FUNCTION person_get_action_type(in_id INT(11))  RETURNS VARCHAR(32) DETERMINISTIC
    BEGIN
        
        DECLARE v_ret VARCHAR(32);
        SET v_ret= '';
        SELECT action_type INTO v_ret  FROM Person WHERE id = in_id  LIMIT 1;
        RETURN v_ret;
    END $$
DELIMITER ;