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 causes a lot of calls to be made to get the data instead of
setting them one time (for most items). I've been told that the table
will probably be cached so it will cost very little.
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
-------- Original Message --------
Subject: [GENERAL] Conditionnal validation for transaction
From: Florent THOMAS <mailinglist@tdeo.fr>
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-conditionnelle-de-transaction-62
2 - Is there a way to declare local variables for a SQL statement
without beiing in a function?
regards