On 11/10/2011 20:54, Java Services wrote: > 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
As the message says, in pl/pgsql you need to specify a destination for the returned data: create or replace function.... as $$ declare my_value .... begin select function_b() into my_value; (etc) If you don't need the return value of function_b(), or if it returns void, then use PERFORM instead: perform function_b(); Gory details here: www.postgresql.org/docs/9.1/static/plpgsql-statements.html HTH Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
