Received: from graal.ensma.fr (graal.ensma.fr [193.55.167.3]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f95Da4n13927 for ; Fri, 5 Oct 2001 09:36:04 -0400 (EDT) (envelope-from mimoune@ensma.fr) Received: from Wallace (wallace.ensma.fr [193.55.163.113]) by graal.ensma.fr (8.9.1b+Sun/8.9.1) with SMTP id PAA14363 for ; Fri, 5 Oct 2001 15:34:15 +0100 (WET DST) Message-ID: <012401c14da2$d80791e0$71a337c1@ensma.fr> From: "Mourad EL HADJ MIMOUNE" To: References: <200110042320.f94NKDg53681@server1.pgsql.org> Subject: SQL-Programmer tool and field%type support Date: Fri, 5 Oct 2001 15:37:14 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200110/81 X-Sequence-Number: 5036 Hi, I'm looking for PL/SQL programmer tool. I wanted to use SQL-Programmer but it doesn't support Postgres data base. Please can sommeone suggest me an other tool wich can replace this one or explaine me how we can use SQLProgrammer with Postgres if it is possible. I have an other question about the use of %type and alias in PL/SQL. So the excution of functions containing varibales of type maytable.field1%type prompts parser errors. error on the creation of the function : create function test (int) returns maytable.field1%type as' ... parser: parse error at or near "." error on the excution of the function : create function test (int) returns int as' declare var1 maytable.field1%type; var2 alias for $1; .... parser: parse error at or near '%' parser: parse error at or near "$1" Please help me. Thanks. Mourad.