Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 10A652E00DB
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 08:16:40 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 68000-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 08:16:30 -0400 (AST)
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id A39D62E005F
	for <pgsql-sql@postgresql.org>; Fri, 15 Feb 2008 08:16:36 -0400 (AST)
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Fri, 15 Feb 2008 13:16:33 +0100
Message-Id: <47B590A4.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Fri, 15 Feb 2008 13:16:21 +0100
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: <pgsql-sql@postgresql.org>
Cc: "Jyoti Seth" <jyotiseth2001@gmail.com>
Subject: Re: Packages
References: <004801c86fc8$685ce580$3916b080$@com>
In-Reply-To: <004801c86fc8$685ce580$3916b080$@com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__Part9DBB6285.1__="
X-imss-version: 2.049
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/124
X-Sequence-Number: 30215

--=__Part9DBB6285.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

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",=20
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,
=20
Is there any concept of Package in postgresql to group functions ?
=20
Thanks,
Jyoti Seth

--=__Part9DBB6285.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>As far as I know not like it exists in Oracle.</DIV>
<DIV>Alternatively you can use a schema per package, but it doesn't solve =
eg package variables and constants.</DIV>
<DIV>Personally I just let my functionnames start with the "package name", =
</DIV>
<DIV>so I have general_log(...), general_log_err(...), replicate_exact(...)=
, replicate_faulty(...), replicate_invoice(...), ...</DIV>
<DIV>I have replaced my package constants by writing a const(...) =
function.</DIV>
<DIV>I avoice package variables and if I do need them, I put them in a =
table.<BR><BR>&gt;&gt;&gt; "Jyoti Seth" &lt;jyotiseth2001@gmail.com&gt; =
2008-02-15 12:46 &gt;&gt;&gt;<BR></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal>Hi,<?xml:namespace prefix =3D o ns =3D "urn:schemas-mi=
crosoft-com:office:office" /><o:p></o:p></P>
<P class=3DMsoNormal><o:p>&nbsp;</o:p></P>
<P class=3DMsoNormal>Is there any concept of Package in postgresql to =
group functions ?<o:p></o:p></P>
<P class=3DMsoNormal><o:p>&nbsp;</o:p></P>
<P class=3DMsoNormal>Thanks,<o:p></o:p></P>
<P class=3DMsoNormal>Jyoti Seth<o:p></o:p></P></DIV></BODY></HTML>

--=__Part9DBB6285.1__=--