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
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
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
2. The short answer is No. I've got the same issue. I come from a
different sql that had a CREATE VARAIBLE which was good for the session.
With PostGres, I've created a sessionsettings table and a bunch of
functions to get by variable and use the value. My perceived downside
is that this cause
