X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D277C537A4 for ; Fri, 15 Apr 2005 19:17:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40455-03 for ; Fri, 15 Apr 2005 22:17:32 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id DD67752961 for ; Fri, 15 Apr 2005 19:17:32 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j3FMHWTE041995 for ; Fri, 15 Apr 2005 22:17:32 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j3FLs9gG035760 for pgsql-sql@postgresql.org; Fri, 15 Apr 2005 21:54:09 GMT (envelope-from news) From: CoL X-Newsgroups: pgsql.sql Subject: Re: How to Port Oracle's user defined "Package" into Postgres 8.0.1. Date: Fri, 15 Apr 2005 23:58:58 +0200 Organization: Hub.Org Networking Services Lines: 15 Message-ID: References: <20050411134150.F0F0153374@svr1.postgresql.org> Reply-To: col@mportal.hu Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8b2) Gecko/20050303 In-Reply-To: <20050411134150.F0F0153374@svr1.postgresql.org> To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/264 X-Sequence-Number: 21157 hi, Dinesh Pandey wrote, On 4/11/2005 15:39: > > > Hi folks, > > Can any one give me an idea about: > > How to Port Oracle's user defined "Package" into Postgres 8.0.1. there is no Package in postgresql. You have to rewrite the logic, extract the functions from Package and recreate them for postgres. But you can't port 1:1 oracle packages to pg. C.