no aoutput from plpgsql-function
От
Cornelia Boenigk
Тема
no aoutput from plpgsql-function
Дата
Msg-id
000701c1c521$4b15d840$aec1fea9@zwerg98
Список
Hello everybody
I am trying to write a plpgsql-function. The function-body is as follows:
declare
autor alias $1;
begin
return p_id from publikation (here are two joins) where m_name = ''autor'';
end;
When I run this function, I get no output. psql shows me:
test=# select suche('Egon');
suche
-------
(1 row)
Can someone give me a hint why the function does'nt display the value of the id? It is existing in the table and it is not a NULL-value.
Thanks
Conni
В списке pgsql-general по дате отправления
От: Tom Lane
Дата: