Re: SQL-Programmer tool and field%type support

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>, Mourad EL HADJ MIMOUNE <mimoune(at)ensma(dot)fr>, pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL-Programmer tool and field%type support
Date: 2001-10-09 04:34:07
Message-ID: 21023.1002602047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-10-09 04:42:41 Re: ROUND function ??
Previous Message Dan Wilson 2001-10-09 04:04:24 Re: PEAR Problem