Re: SQL-Programmer tool and field%type support - Mailing list pgsql-sql

"Josh Berkus" <josh@agliodbs.com> writes:
> 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.

It does work in 7.2devel, however ...
        regards, tom lane