Re: plpgsql functions organisation
От | Adrian Klaver |
---|---|
Тема | Re: plpgsql functions organisation |
Дата | |
Msg-id | 55452DEE.1070701@aklaver.com обсуждение исходный текст |
Ответ на | Re: plpgsql functions organisation (Melvin Davidson <melvin6925@gmail.com>) |
Ответы |
Re: plpgsql functions organisation
|
Список | pgsql-general |
On 05/02/2015 10:12 AM, Melvin Davidson wrote: > AFAIK, you cannot "package" functions in PostgreSQL, but it is possible to > call a function from within a function. > > That being said, I would seriously look at how and why you are writing > your functions > as functions that call other functions are not very efficient. I am not following. That is what packaging is about, separating out 'units of work' so they can be combined as needed. Part of that is using existing functions in new functions/classes. In fact in the Postgres source I see this in many places. Now it is entirely possible I missed a memo, so I am open to a more detailed explanation of the inefficiencies involved. > > Also note that PostgreSQL allows you define functions using Python, so > that might be a possible compromise. > > On Sat, May 2, 2015 at 12:53 PM, Yves Dorfsman <yves@zioup.com > <mailto:yves@zioup.com>> wrote: > > > I find my plpgsql functions becomes unreadable very quickly. I want > to break > them up in smaller functions. > > What is the best way to organised them? > Is there any way to define functions inside functions? > When I list functions in psql, I can see them all at the same level, > is there > any way to organise them in packages like with python and other > languages, so > the smaller functions are hidden away in a package/directory? > > > Thanks. > > -- > http://yves.zioup.com > gpg: 4096R/32B0F416 > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org > <mailto:pgsql-general@postgresql.org>) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: