"Josh Berkus" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
