Re: [GENERAL] Conditionnal validation for transaction

2012-03-20 Thread Albe Laurenz
Florent THOMAS wrote: >>> 1 - Is there a way to have conditions for committing transactions like in oracle : >>> http://www.scribd.com/doc/42831667/47/Validation-conditionnelle-de-trans action-62 >> >> PostgreSQL follows the SQL standard which does not allow anything like that. >> >> Later versio

Re: [GENERAL] Conditionnal validation for transaction

2012-03-19 Thread Florent THOMAS
Le 19/03/2012 16:57, Simon Riggs a écrit : On Mon, Mar 19, 2012 at 3:28 PM, Florent THOMAS 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

Re: [GENERAL] Conditionnal validation for transaction

2012-03-19 Thread Simon Riggs
On Mon, Mar 19, 2012 at 3:28 PM, Florent THOMAS 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

Re: [GENERAL] Conditionnal validation for transaction

2012-03-19 Thread mgould
bject: [GENERAL] Conditionnal validation for transaction From: Florent THOMAS Date: Mon, March 19, 2012 8:28 am To: pgsql-general@postgresql.org 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-co

[GENERAL] Conditionnal validation for transaction

2012-03-19 Thread Florent THOMAS
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? regards