Le 19/03/2012 16:57, Simon Riggs a écrit : Thanks, Could you precise the sentence bellowOn Mon, Mar 19, 2012 at 3:28 PM, Florent THOMAS <mailinglist@xxxxxxx> 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. How do you do that?But then you don't need to because you can do a conditional error or drop through to a commit. Regards |