Mam taki błąd:
control reached end of function without RETURN
wywlouje zapytanie:
SELECT adduser('[email protected]','gg4wg342g4g','2011-11-29 01:13:40.349614+01');
A funkcje zrobilem:
CREATE OR REPLACE FUNCTION adduser(email_var character varying,password_var character varying, time_date_add_var timestamp without time zone)
RETURNS integer AS
$BODY$
DECLARE
ret_id bigint;
BEGIN
INSERT INTO users
(
email,
password,
time_date_add
)
VALUES
(
email_var,
password_var,
time_date_add_var
)
RETURNING id INTO ret_id;
END;
$BODY$
LANGUAGE plpgsql;
co moze byc zle ? chcialem zeby funkcja zwracala mi ID wstawionego rekordu