> -----Original Message----- > From: Guillaume Lelarge [mailto:guillaume@xxxxxxxxxxxx] > Sent: Tuesday, May 11, 2010 11:56 AM > To: Tom Lane > Cc: Dino Vliet; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: can function arguments have the type > tablename.columnname%TYPE? > > Le 11/05/2010 16:16, Tom Lane a écrit : > > Guillaume Lelarge <guillaume@xxxxxxxxxxxx> writes: > >> Le 11/05/2010 10:28, Dino Vliet a écrit : > >>> I'm writing a plpgsql function in pgadminIII and want to > know if the arguments can have the following type: > >>> > >>> tablename.columnname%TYPE > > > >> No, this construct is only available *inside* a PL/pgsql function > >> body > > > > That's incorrect: you can use it in a function declaration too. > > > > Oh sure. With body, I meant the part between the two $$. But > you're right, I should have said "inside the declare and body > parts of a PL/pgsql function". > > > Not sure what the OP's problem is exactly --- it might be > specific to > > pgAdmin. > > IIUC, he means doing something like this: > > CREATE FUNCTION f1(arg1 table.column%TYPE ... > > Which, AFAICT, is not possible. And you can't do that with > pgAdmin, but you can use the %TYPE in the declare and body > parts in pgAdmin. > > > -- > 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 > Guillaume, 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. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
