Postgres Pro
Downloads
Home   >   mailing lists

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 4BE91C31.9090309@lelarge.info
Whole thread Raw
In response to can function arguments have the type tablename.columnname%TYPE?  (Dino Vliet <dino_vliet@yahoo.com>)
Responses Re: can function arguments have the type tablename.columnname%TYPE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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.


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

pgsql-general by date:

Previous
From: Jason Armstrong
Date:
Subject: Workqueue performance
Next
From: Alexander Pyhalov
Date:
Subject: Re: log database in which error occurs