Re: Calling a function within a function - plpsql - Mailing list pgsql-novice

From Godshall Michael
Subject Re: Calling a function within a function - plpsql
Date
Msg-id A596FA3368757645AF862C701495CA0001B44672@hor1mspmx01.gmachs.com
Whole thread Raw
In response to Calling a function within a function - plpsql  (Godshall Michael <Michael_Godshall@gmachs.com>)
List pgsql-novice

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@sss.pgh.pa.us]
Sent: Thursday, September 25, 2003 3:10 PM
To: Godshall Michael
Cc: 'pgsql-novice@postgresql.org'
Subject: Re: [NOVICE] Calling a function within a function - plpsql

Godshall Michael <Michael_Godshall@gmachs.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

pgsql-novice by date:

Previous
From: Heath Tanner
Date:
Subject: Re: Function return type does not match
Next
From: "vijay"
Date:
Subject: Re: Backing Up a Postgres database...