X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D673AD1B8F5 for ; Wed, 20 Aug 2003 17:43:07 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 91050-08 for ; Wed, 20 Aug 2003 17:42:57 -0300 (ADT) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.103]) by svr1.postgresql.org (Postfix) with ESMTP id 5ED02D1B96D for ; Wed, 20 Aug 2003 17:42:40 -0300 (ADT) Received: from roberto by brasileiro.net with local (Exim 3.36 #1 (Debian)) id 19paFl-0006st-00; Wed, 20 Aug 2003 15:12:25 -0600 Date: Wed, 20 Aug 2003 15:12:25 -0600 From: Roberto Mello To: Jomon Skariah Cc: pgsql-sql@postgresql.org Subject: Re: Porting from PL/SQL to PLPGSQL Message-ID: <20030820211225.GA26409@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/245 X-Sequence-Number: 14861 On Wed, Aug 20, 2003 at 03:15:23PM +0530, Jomon Skariah wrote: > > we are facing a few problems with PL/SQL Code.. > > > 1) In Oracle sqlplus we can run sql script files as @script_name; > How do we do the same in PostGres. psql takes \i. See psql's \? See the "Porting From Oracle PL/SQL" document I wrote that is part of the PL/pgSQL documentation. > Also is there any replacement for "&&" in PostGres ? > > > Eg: > CREATE USER CATALOG > IDENTIFIED BY &ORA_PASSWORD > DEFAULT TABLESPACE &DFLT_TABLESPACE > TEMPORARY TABLESPACE &TEMP_TABLESPACE What does that do? > > 2) In PostGres a function can not take more 16 arguments.We have some > procedures which are taking more than > 16 arguements.So how can we convert them into PostGres. You can recompile to change the number of parameters. PG 7.3 can have up to 32 arguments by default, IIRC. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + It's now the GNU Emacs of all terminal emulators. -- Linus Torvalds, regarding the fact that Linux started off as a terminal emulator