Re: Conditionnal validation for transaction

Le 19/03/2012 16:57, Simon Riggs a écrit :
> On Mon, Mar 19, 2012 at 3:28 PM, Florent THOMAS<mailinglist(at)tdeo(dot)fr> wrote:
>> Hy all of you,
>>
>> 1 - Is there a way to have conditions for committing transactions like in
>> oracle :
>> http://www.scribd.com/doc/42831667/47/Validation-conditionnelle-de-transaction-62
>>
>> 2 - Is there a way to declare local variables for a SQL statement without
>> beiing in a function?
> PostgreSQL follows the SQL standard which does not allow anything like that.
>
> Later versions do allow anonymous blocks, also known as DO statements
> that allow you to execute some code to allow decision making like
> that. So the Oracle example is very similar code in PostgreSQL, except
> that you can't issue ROLLBACK and COMMIT.
Thanks, Could you precise the sentence bellow
> But then you don't need to
> because you*can do a conditional error or drop through to a commit*.
How do you do that?

Regards