From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Java Services <jvsrvcs(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to call a stored function from another stored function? even possible? |
Date: | 2011-10-11 21:23:45 |
Message-ID: | 4E94B3E1.4050501@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2011-10-11 21:29:37 | Re: how to save primary key constraints |
Previous Message | J.V. | 2011-10-11 21:16:21 | how to save primary key constraints |