On Oct 11, 2011, at 15:54, Java Services <jvsrvcs@xxxxxxxxx> 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 > > ********** Error ********** > > > any ideas? If you want to discard the results of a SELECT, use PERFORM instead. See 39.5.2 David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general