Re: Use of %ROWTYPE in plpgsql function declarations
От | Karl O. Pinc |
---|---|
Тема | Re: Use of %ROWTYPE in plpgsql function declarations |
Дата | |
Msg-id | 1133676411l.28211l.8l@mofo обсуждение исходный текст |
Ответ на | Re: Use of %ROWTYPE in plpgsql function declarations (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Use of %ROWTYPE in plpgsql function declarations
|
Список | pgsql-general |
On 12/03/2005 11:31:34 PM, Tom Lane wrote: > "Karl O. Pinc" <kop@meme.com> writes: > > Speaking of documentation, it's none too clear that > > %ROWTYPE does not seem to work when declaring plpgsql > > functions. > > There is noplace that claims that it does. Perhaps you > are looking for %TYPE? Nope. I saw this: ----<snip>----- 36.4.3. Row Types ... Parameters to a function can be composite types (complete table rows). In that case, the corresponding identifier $n will be a row variable, and fields can be selected from it, for example $1.user_id. ----<snip>----- and figured that if it was a row variable I could/should declare it as such when defining the function. It just seemed a little wierd not to have the %ROWTYPE because AFIK you need it when declaring in plpgsql's DECLARE and otherwise the function argument declarations look like DECLARE declarations. No biggie. Figured I'd throw it out there (to keep me away from my real work. ;) Karl <kop@meme.com> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein
В списке pgsql-general по дате отправления: