pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Packages
2+ messages / 2 participants
[nested] [flat]

* Packages
@ 2008-02-15 11:46 Jyoti Seth <jyotiseth2001@gmail.com>
  2008-02-15 12:16 ` Re: Packages Bart Degryse <Bart.Degryse@indicator.be>
  0 siblings, 1 reply; 2+ messages in thread

From: Jyoti Seth @ 2008-02-15 11:46 UTC (permalink / raw)
  To: pgsql-sql

Hi,

 

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

 

Thanks,

Jyoti Seth

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Packages
  2008-02-15 11:46 Packages Jyoti Seth <jyotiseth2001@gmail.com>
@ 2008-02-15 12:16 ` Bart Degryse <Bart.Degryse@indicator.be>
  0 siblings, 0 replies; 2+ messages in thread

From: Bart Degryse @ 2008-02-15 12:16 UTC (permalink / raw)
  To: pgsql-sql; +Cc: Jyoti Seth <jyotiseth2001@gmail.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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2008-02-15 12:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-15 11:46 Packages Jyoti Seth <jyotiseth2001@gmail.com>
2008-02-15 12:16 ` Bart Degryse <Bart.Degryse@indicator.be>

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