Postgres Pro
Downloads
Home   >   mailing lists

how to call a stored function from another stored function? even possible? - Mailing list pgsql-general

From Java Services
Subject how to call a stored function from another stored function? even possible?
Date
Msg-id CADq_mb-jP-b75zaiVzXcRWzfYOtu+5Y2oyMT9GydgKBjfVEtjg@mail.gmail.com
Whole thread Raw
Responses Re: how to call a stored function from another stored function? even possible?  (David Johnston <polobo@yahoo.com>)
Re: how to call a stored function from another stored function? even possible?  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Eric Radman
Date:
Subject: Re: Global Variables?
Next
From: salah jubeh
Date:
Subject: Re: libpq 8.3 and 8.4 interfaces