Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f994Ycn86655 for ; Tue, 9 Oct 2001 00:34:38 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f994Y7I21026; Tue, 9 Oct 2001 00:34:07 -0400 (EDT) To: "Josh Berkus" cc: Roberto Mello , Mourad EL HADJ MIMOUNE , pgsql-sql@postgresql.org Subject: Re: SQL-Programmer tool and field%type support In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Mon, 08 Oct 2001 16:08:05 -0700" Date: Tue, 09 Oct 2001 00:34:07 -0400 Message-ID: <21023.1002602047@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200110/128 X-Sequence-Number: 5083 "Josh Berkus" 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