Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Bart DegryseDate: 2008-02-15 12:18:47
Subject: Re: Function description
Previous:From: Gavin 'Beau' BaumanisDate: 2008-02-15 11:46:43
Subject: Re: Function description

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group