Mourad,
> > 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' ...
What Roberto is saying is that the declaration:
DECLARE
v_field1 mytable.field1%type
is supported internal to a PL/pgSQL function, but
CREATE FUNCTION test1(int) RETURNS mytable.filed1%type
is not. This is because the %type declaration is supported in PL/pgSQL,
but not in Postgres SQL.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
