Ying Lu wrote:
> Greetings,
>
> I have a question about whether I am able to create an *anonymous*
> procedure/function under postgreSQL 8. Something like:
>
> Begin
> ... ...
> update ...
> IF ... THEN
> rollback
> END IF;
> ... ...
> END;
No
> I'd like to do a series of operations. If any one of the opers failed,
> all previous operation will rollback.
Well that's just a transaction.
> Actually, I do not want to create
> named functions. Just used the structure for different tables with minor
> changes.
Create your function, call it, drop it.
> Another question is about how to create a function/procedure do not need
> a return value (void for return value). It seems that postgreSQL forces
> to return some value?
Just return a boolean.
--
Richard Huxton
Archonet Ltd