Re: Packages - Mailing list pgsql-sql

From Bart Degryse
Subject Re: Packages
Date
Msg-id 47B590A4.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Packages  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
List 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@gmail.com> 2008-02-15 12:46 >>>

Hi,

 

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

 

Thanks,

Jyoti Seth

pgsql-sql by date:

Previous
From: Gavin 'Beau' Baumanis
Date:
Subject: Re: Function description
Next
From: "Bart Degryse"
Date:
Subject: Re: Function description