Re: can function arguments have the type tablename.columnname%TYPE? - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: can function arguments have the type tablename.columnname%TYPE?
Date
Msg-id 4BEACC45.5020402@lelarge.info
Whole thread Raw
In response to Re: can function arguments have the type tablename.columnname%TYPE?  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-general
Le 12/05/2010 16:56, Igor Neyman a écrit :
> [...]
> I'm not sure why are you instisting that:
>
>> CREATE FUNCTION f1(arg1 table.column%TYPE ...
>>
>> Which, AFAICT, is not possible.
>
> It is definetily possible, i.e:
>
> CREATE OR REPLACE FUNCTION myMaxCycle(i_n_Cell_id GP_CELL.cell_id%TYPE)
> RETURNS GP_CYCLE.cycle_date_time%TYPE
> AS $$...
>
> Works in my 8.2 PG.
>

After looking in the manual, it seems you're right. Sorry about this.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: Question about Beta for Windows 64 bits
Next
From: Richard Broersma
Date:
Subject: Reliability of Windows versions 8.3 or 8.4