how to call a stored function from another stored function? even possible?

From: Java Services <jvsrvcs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to call a stored function from another stored function? even possible?
Date: 2011-10-11 19:54:54
Message-ID: CADq_mb-jP-b75zaiVzXcRWzfYOtu+5Y2oyMT9GydgKBjfVEtjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a stored functionA that returns void

Inside there I have a line that says:
select functionB();

and it gives this error.

ERROR: query has no destination for result data
HINT: If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT: PL/pgSQL function "functionA" line 13 at SQL statement

********** Error **********

any ideas?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message salah jubeh 2011-10-11 19:55:01 Re: libpq 8.3 and 8.4 interfaces
Previous Message Eric Radman 2011-10-11 19:53:15 Re: Global Variables?