SQL-Programmer tool and field%type support

From: "Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)fr>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: SQL-Programmer tool and field%type support
Date: 2001-10-05 13:37:14
Message-ID: 012401c14da2$d80791e0$71a337c1@ensma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Papp Gyozo 2001-10-05 13:42:41 Re: Need Help!!
Previous Message Bhuvan A 2001-10-05 13:28:38 COPY COMMAND -- Hanging