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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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