Re: Calling a function within a function - plpsql

Thank you for the response. I found the syntax error. Function(b) was
defined to return void so I assumed that when I called function(b) in
function(a) that I did not need to assign the result(or lack of in this
case) to a variable.

Mike

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, September 25, 2003 3:10 PM
To: Godshall Michael
Cc: 'pgsql-novice(at)postgresql(dot)org'
Subject: Re: [NOVICE] Calling a function within a function - plpsql

Godshall Michael <Michael_Godshall(at)gmachs(dot)com> writes:
> I have created a function(a) that within this function(a) another
> function(b) is called. When I execute function(a) I am getting a syntax
> error near ; message.
> When I comment out the line of code that calls function(b) then
function(a)
> works fine.
> When I execute function(b) on its own function(b) works fine.

> Does psql support a function calling other functions?

Certainly. You're making some syntax error or other, but since you've
not shown us your code, we cannot help much.

regards, tom lane