RES: Let's make CPgAN! - Mailing list pgsql-general

From Alejandro Michelin Salomon \( Adinet \)
Subject RES: Let's make CPgAN!
Date
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAhx491Ki2tUS42D/aMPFg1MKAAAAQAAAA9XYoY8mrS0Oc+ZBsknG+8AEAAAAA@adinet.com.uy
Whole thread Raw
In response to Re: Let's make CPgAN!  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-general
Hi Florian :

Oracle has packages.

Packages are collections of functions, procedures, variables, constants,
ect, put all together.

You has two commands

CREATE PACKAGES, CREATE PACKAGES BODY.

CREATE PACKAGES this creates the definations, list of components, and the
name.

CREATE PACKAGES BODY is components defination. Components code.

You can have information global to packages, is this, share information
between function and other components via global variables or constants.

Is usefull to make a packages for manage logic of a system. In place of
create function, procedures, etc, all individual.
You can put all logic together.

Oracle has many prefined packages, to make most commonly task.

Alejandro Michelin Salomon
Porto Alegre
Brasil


-->-----Mensagem original-----
-->De: pgsql-general-owner@postgresql.org
-->[mailto:pgsql-general-owner@postgresql.org] Em nome de
-->Florian G. Pflug
-->Enviada em: segunda-feira, 22 de maio de 2006 12:39
-->Para: Agent M
-->Cc: Postgres general mailing list
-->Assunto: Re: [GENERAL] Let's make CPgAN!
-->
-->
-->Agent M wrote:
-->> I think the implementation of postgresql installable packages (and
-->> package-space) should precede this idea. Then, any package
-->management
-->> system can install the packages.
-->
-->Having a standardizes package management for postgresql
-->would be great. I believe one could use schemas to
-->encapsulate installed packages, but maybe some backend
-->support would be necessary for dependency tracking.
-->
-->Oracle seems to support some kind of "package" concept -
-->does anyone know any details?
-->
-->greetings, Florian Pflug
-->
-->
-->---------------------------(end of
-->broadcast)---------------------------
-->TIP 5: don't forget to increase your free space map settings
-->
-->
-->--
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.392 / Virus Database: 268.7.0/345 - Release
-->Date: 22/5/2006
-->
-->
-->--
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.392 / Virus Database: 268.7.0/345 - Release
-->Date: 22/5/2006
-->
-->

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.7.0/345 - Release Date: 22/5/2006




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.7.0/345 - Release Date: 22/5/2006


pgsql-general by date:

Previous
From: "Michael Schmidt"
Date:
Subject: Changes in pl/pgsql?
Next
From: "Brendan Jurd"
Date:
Subject: Re: No stddev() for interval?