`DO
$$
DECLARE lang TEXT;
myvar dictionary_keys_view.it%TYPE;
begin
lang = 'it';
SELECT INTO myvar lang FROM dictionary_keys_view WHERE key = 'ENDED';
raise notice 'title id: %', myvar;
end;
$$;`
When i execute this in pgadmin i receive: ” NOTICE: title id: it
DO
Query returned successfully in 101 msec.”
where’s the error? thanks in advance
i tried to declare in different ways the lang var but i never used plpgsql
New contributor