Re: Private or publice function

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(at)archonet(dot)com> 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(at)postgresql(dot)org)
>

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