of course hitting post made me realize what the error was.
EVERY block within pgplsql must end with a ';'. (can I say : old habits die
Sorry for the noice.
View this message in context: http://postgresql.1045698.n5.nabble.com/starting-on-functions-with-little-succes-tp4557235p4559083.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
In response to
pgsql-novice by date
|Next:||From: Michèle Garoche||Date: 2011-07-06 22:59:42|
|Subject: Request over partition and join|
|Previous:||From: Odysseus||Date: 2011-07-06 21:57:49|
|Subject: Re: starting on functions (with a bit more succes)|