Re: Packages

From: "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "Jyoti Seth" <jyotiseth2001(at)gmail(dot)com>
Subject: Re: Packages
Date: 2008-02-15 12:16:21
Message-ID: 47B590A4.A3DD.0030.0@indicator.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)gmail(dot)com> 2008-02-15 12:46 >>>

Hi,

Is there any concept of Package in postgresql to group functions ?

Thanks,
Jyoti Seth

In response to

  • Packages at 2008-02-15 11:46:27 from Jyoti Seth

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2008-02-15 12:18:47 Re: Function description
Previous Message Gavin 'Beau' Baumanis 2008-02-15 11:46:43 Re: Function description