Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux