Re: Private or publice function

[Nirmalya Lahiri <nirmalyalahiri@xxxxxxxxx>]

Thanks Richard,
 for your reply. Now I am explaining you what I want.
Let I have 4
functions......function_1(),function_2(),function_3(),function_4().


create or replace function function_1() returns numeric as '
begin
 create or replace function function_2() returns numeric as ''
 begin 
  --------
  --------
 end;
 '' language plpgsql
 -----------
 -----------
 -----------
 create or replace function function_3() returns numeric as ''
 begin
  ---------
  ---------
 end;
 '' language plpgsql
end ;
' language plpgsql



create or replace function function_4() returns numeric as '
begin 
 -----------
 -----------
end;
' language plpgsql


 Now after creating these functions, I can easily call every function
from psql prompt. But I want to encapsulate function_2() and
function_3() withen function_1(), so that no one can call
function_2() and function_3() from psql prompt and from function_4(),
only from withen the function_1() I can call function_2() and
function_3().

 Is it possible in PostgreSQL?

Nirmalya Lahiri


--- Richard Huxton <dev@xxxxxxxxxxxx> wrote:

> Nirmalya Lahiri wrote:
> > Hi,
> >  How can I create a publice or private function?
> 
> I'm not sure the concept makes sense in PostgreSQL. Can you explain
> what 
> you're trying to achieve?
> 
> -- 
>    Richard Huxton
>    Archonet Ltd
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister
> command
>     (send "unregister YourEmailAddressHere" to
> majordomo@xxxxxxxxxxxxxx)
> 



		
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx