Polskie Forum Użytkowników Debiana

Kod: Zaznacz cały

ERROR:  syntax error at or near "user"
LINE 1: ...ON update_password (oldpass text, cryptpass text, user text)...
                                                             ^

Kod: Zaznacz cały

CREATE FUNCTION update_password (oldpass text, cryptpass text, puser text) RETURNS text AS ' 
        BEGIN             
            DECLARE currentsalt varchar(20); 
            DECLARE error text;
            SET error = 'incorrect current password'; 
            SELECT substring_index(substr(puser.password,4),_latin1'$',1) INTO currentsalt FROM users WHERE username=puser;
            SELECT '' INTO error FROM users WHERE username=puser AND password=ENCRYPT(oldpass,currentsalt);
            UPDATE users SET password=cryptpass WHERE username=puser AND password=ENCRYPT(oldpass,currentsalt);
            RETURN error;
        END; '  language 'SQL';