Search Postgresql Archives

Re: can function arguments have the type tablename.columnname%TYPE?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux