From jyotiseth2001@gmail.com Fri Feb 15 11:47:25 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CF4CA2E00DC for ; Fri, 15 Feb 2008 07:47:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81179-06 for ; Fri, 15 Feb 2008 07:47:21 -0400 (AST) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.190]) by postgresql.org (Postfix) with ESMTP id 05CFA2E0052 for ; Fri, 15 Feb 2008 07:47:20 -0400 (AST) Received: by rv-out-0910.google.com with SMTP id g13so508875rvb.43 for ; Fri, 15 Feb 2008 03:47:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:content-language; bh=z3eZI80aRZBm655R1x4fd1BKQdP55E/NMY/VwOeZqyY=; b=yCsRn7GRb4IOfJOp3humid8JhvprsF5TMlCwkisL429FD56PrvecxvVRzrFPEfaF1gXtdCu11hUwJXr9Jqop//XBt91Z0YRVvdr7g2xA80w1qWStuCusLAvKls2ne/DXJiXAfGH3VwxWyva9xzPwcEiil5hQ9m6qe1XN5ig9sXo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:content-language; b=GFZNAF2pS8ue7H49cGSQHNKrQtbdeU5xEhpv3UJBhrM0CD6BMmEI/+nVoah7SgXGB+DNDIBDxrrfrtujZn8n9rQ/0y08hR/qDQtomFu4g7noed75QaboXYOoyJv11X9GNSl1T07dtyUfe2/o96VU/Ox0tf9PCf0IjfyNsXI5FFQ= Received: by 10.140.88.11 with SMTP id l11mr1808209rvb.156.1203076036628; Fri, 15 Feb 2008 03:47:16 -0800 (PST) Received: from BITDLLT03 ( [122.162.171.246]) by mx.google.com with ESMTPS id f36sm645849rvb.4.2008.02.15.03.47.13 (version=SSLv3 cipher=RC4-MD5); Fri, 15 Feb 2008 03:47:15 -0800 (PST) From: "Jyoti Seth" To: Subject: Packages Date: Fri, 15 Feb 2008 17:16:27 +0530 Message-ID: <004801c86fc8$685ce580$3916b080$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0049_01C86FF6.82152180" X-Mailer: Microsoft Office Outlook 12.0 thread-index: AchvyGXN/17UsicZTNe0aVM6v4OL9g== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/122 X-Sequence-Number: 30213 This is a multipart message in MIME format. ------=_NextPart_000_0049_01C86FF6.82152180 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, Is there any concept of Package in postgresql to group functions ? Thanks, Jyoti Seth ------=_NextPart_000_0049_01C86FF6.82152180 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

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

Thanks,

Jyoti Seth

------=_NextPart_000_0049_01C86FF6.82152180-- From Bart.Degryse@indicator.be Fri Feb 15 12:16:40 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 10A652E00DB for ; 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 ; 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 ; 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" To: Cc: "Jyoti Seth" 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" 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

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

--=__Part9DBB6285.1__=--