no aoutput from plpgsql-function - Mailing list pgsql-general

From Cornelia Boenigk
Subject no aoutput from plpgsql-function
Date
Msg-id 000701c1c521$4b15d840$aec1fea9@zwerg98
Whole thread Raw
List pgsql-general
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
nota NULL-value.  

Thanks
Conni


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: table size
Next
From: Tom Lane
Date:
Subject: Re: Archiver(custom): could not initialize compression library - (null)