plpgsql functions organisation

From: Yves Dorfsman <yves(at)zioup(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql functions organisation
Date: 2015-05-02 16:53:47
Message-ID: 5545011B.7090901@zioup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2015-05-02 17:12:08 Re: plpgsql functions organisation
Previous Message Paul Jungwirth 2015-05-02 15:55:22 Re: Success story full text search