From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
Cc: Jyoti Seth <jyotiseth2001@gmail.com>
Subject: Re: Packages
Date: Fri, 15 Feb 2008 13:16:21 +0100
Message-ID: <47B590A4.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <004801c86fc8$685ce580$3916b080$@com>
References: <004801c86fc8$685ce580$3916b080$@com>
As far as I know not like it exists in Oracle.
Alternatively you can use a schema per package, but it doesn't solve eg package variables and constants.
Personally I just let my functionnames start with the "package name",
so I have general_log(...), general_log_err(...), replicate_exact(...), replicate_faulty(...), replicate_invoice(...), ...
I have replaced my package constants by writing a const(...) function.
I avoice package variables and if I do need them, I put them in a table.
>>> "Jyoti Seth" <jyotiseth2001@gmail.com> 2008-02-15 12:46 >>>
Hi,
Is there any concept of Package in postgresql to group functions ?
Thanks,
Jyoti Seth
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, jyotiseth2001@gmail.com
Subject: Re: Packages
In-Reply-To: <47B590A4.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox