"Josh Berkus" <josh(at)agliodbs(dot)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