Skip site navigation (1) Skip section navigation (2)

Re: Calling a function within a function - plpsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Godshall Michael <Michael_Godshall(at)gmachs(dot)com>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Calling a function within a function - plpsql
Date: 2003-09-25 20:10:13
Message-ID: 28670.1064520613@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: radha.manoharDate: 2003-09-25 20:48:22
Subject: Re: Concurrency control
Previous:From: Juan Francisco DiazDate: 2003-09-25 19:09:39
Subject: Re: Function return type does not match

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group